Chicago Collision Data Profiling

Dataset statistics

Number of variables	48
Number of observations	817723
Missing cells	8268003
Missing cells (%)	21.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	299.5 MiB
Average record size in memory	384.0 B

Variable types

Text	3
Boolean	9
DateTime	2
Numeric	15
Categorical	19

Alerts

`INJURIES_UNKNOWN` has constant value ""	Constant
`BEAT_OF_OCCURRENCE` is highly overall correlated with `LATITUDE` and 1 other fields	High correlation
`CRASH_TYPE` is highly overall correlated with `INJURIES_TOTAL` and 1 other fields	High correlation
`DOORING_I` is highly overall correlated with `FIRST_CRASH_TYPE`	High correlation
`FIRST_CRASH_TYPE` is highly overall correlated with `DOORING_I`	High correlation
`INJURIES_NON_INCAPACITATING` is highly overall correlated with `INJURIES_TOTAL`	High correlation
`INJURIES_REPORTED_NOT_EVIDENT` is highly overall correlated with `INJURIES_TOTAL`	High correlation
`INJURIES_TOTAL` is highly overall correlated with `CRASH_TYPE` and 2 other fields	High correlation
`LANE_CNT` is highly overall correlated with `NOT_RIGHT_OF_WAY_I` and 5 other fields	High correlation
`LATITUDE` is highly overall correlated with `BEAT_OF_OCCURRENCE` and 6 other fields	High correlation
`LONGITUDE` is highly overall correlated with `BEAT_OF_OCCURRENCE` and 6 other fields	High correlation
`MOST_SEVERE_INJURY` is highly overall correlated with `CRASH_TYPE`	High correlation
`NOT_RIGHT_OF_WAY_I` is highly overall correlated with `LANE_CNT` and 2 other fields	High correlation
`PHOTOS_TAKEN_I` is highly overall correlated with `LANE_CNT` and 3 other fields	High correlation
`ROADWAY_SURFACE_COND` is highly overall correlated with `WEATHER_CONDITION`	High correlation
`STATEMENTS_TAKEN_I` is highly overall correlated with `LANE_CNT` and 3 other fields	High correlation
`STREET_NO` is highly overall correlated with `WORKERS_PRESENT_I` and 2 other fields	High correlation
`WEATHER_CONDITION` is highly overall correlated with `ROADWAY_SURFACE_COND`	High correlation
`WORKERS_PRESENT_I` is highly overall correlated with `LANE_CNT` and 4 other fields	High correlation
`WORK_ZONE_I` is highly overall correlated with `LANE_CNT` and 5 other fields	High correlation
`WORK_ZONE_TYPE` is highly overall correlated with `LANE_CNT` and 4 other fields	High correlation
`TRAFFIC_CONTROL_DEVICE` is highly imbalanced (61.7%)	Imbalance
`DEVICE_CONDITION` is highly imbalanced (54.4%)	Imbalance
`WEATHER_CONDITION` is highly imbalanced (66.2%)	Imbalance
`ALIGNMENT` is highly imbalanced (92.0%)	Imbalance
`ROADWAY_SURFACE_COND` is highly imbalanced (55.3%)	Imbalance
`ROAD_DEFECT` is highly imbalanced (69.9%)	Imbalance
`INTERSECTION_RELATED_I` is highly imbalanced (72.4%)	Imbalance
`NOT_RIGHT_OF_WAY_I` is highly imbalanced (55.8%)	Imbalance
`HIT_AND_RUN_I` is highly imbalanced (74.4%)	Imbalance
`SEC_CONTRIBUTORY_CAUSE` is highly imbalanced (54.2%)	Imbalance
`MOST_SEVERE_INJURY` is highly imbalanced (66.7%)	Imbalance
`INJURIES_FATAL` is highly imbalanced (99.4%)	Imbalance
`CRASH_DATE_EST_I` has 756594 (92.5%) missing values	Missing
`LANE_CNT` has 618714 (75.7%) missing values	Missing
`REPORT_TYPE` has 24314 (3.0%) missing values	Missing
`INTERSECTION_RELATED_I` has 630174 (77.1%) missing values	Missing
`NOT_RIGHT_OF_WAY_I` has 780015 (95.4%) missing values	Missing
`HIT_AND_RUN_I` has 561774 (68.7%) missing values	Missing
`PHOTOS_TAKEN_I` has 806948 (98.7%) missing values	Missing
`STATEMENTS_TAKEN_I` has 799465 (97.8%) missing values	Missing
`DOORING_I` has 815211 (99.7%) missing values	Missing
`WORK_ZONE_I` has 813053 (99.4%) missing values	Missing
`WORK_ZONE_TYPE` has 814105 (99.6%) missing values	Missing
`WORKERS_PRESENT_I` has 816529 (99.9%) missing values	Missing
`LANE_CNT` is highly skewed (γ1 = 350.3035967)	Skewed
`LATITUDE` is highly skewed (γ1 = -116.2686453)	Skewed
`LONGITUDE` is highly skewed (γ1 = 127.289911)	Skewed
`CRASH_RECORD_ID` has unique values	Unique
`INJURIES_TOTAL` has 703431 (86.0%) zeros	Zeros
`INJURIES_INCAPACITATING` has 801987 (98.1%) zeros	Zeros
`INJURIES_NON_INCAPACITATING` has 749965 (91.7%) zeros	Zeros
`INJURIES_REPORTED_NOT_EVIDENT` has 777695 (95.1%) zeros	Zeros
`INJURIES_NO_INDICATION` has 17119 (2.1%) zeros	Zeros
`CRASH_HOUR` has 17728 (2.2%) zeros	Zeros

Reproduction

Analysis started	2024-03-29 21:39:43.893303
Analysis finished	2024-03-29 22:15:45.426521
Duration	36 minutes and 1.53 second
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

CRASH_RECORD_ID
Text

UNIQUE

Distinct	817723
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Length

Max length	128
Median length	128
Mean length	128
Min length	128

Characters and Unicode

Total characters	104668544
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	817723 ?
Unique (%)	100.0%

Sample

1st row	6c1659069e9c6285a650e70d6f9b574ed5f64c12888479093dfeef179c0344ec6d2057eae224b5c0d5dfc278c0a237f8c22543f07fdef2e4a95a3849871c9345
2nd row	5f54a59fcb087b12ae5b1acff96a3caf4f2d37e79f8db4106558b34b8a6d2b81af02cf91b576ecd7ced08ffd10fcfd940a84f7613125b89d33636e6075064e22
3rd row	61fcb8c1eb522a6469b460e2134df3d15f82e81fd93e9cafd3dc7e631b9e1ba8b450a63af12bd90d1d2d9b127ea287f88d32e138a4eeba17799f536c08048934
4th row	004cd14d0303a9163aad69a2d7f341b7da2a8572b2ab3378594bfae8ac53dcb604dd8d414f93c290b55862f9f2517ad32e6209cbc8034c2e26eb3c2bc9724390
5th row	a1d5f0ea90897745365a4cbb06cc60329a120d89753fac2b02d69c9685d9cf7c763870a60abd01484a39ed1e6c09b1ba59f38214c03a83cccde1247f794e0287

Value	Count	Frequency (%)
6c1659069e9c6285a650e70d6f9b574ed5f64c12888479093dfeef179c0344ec6d2057eae224b5c0d5dfc278c0a237f8c22543f07fdef2e4a95a3849871c9345	1	< 0.1%
569af2dc0eaa9c5a55a01f1d5fd678644c3dd76d586b51f7b87b1b5c6c3cf8700b10a9fea3c98cfc8df295c8b4db1fe28c4209e34e3a021b50c56023c798d1f9	1	< 0.1%
4a1f7a24129e5e1d4a7a2fd44ab6f8822a20bcdb2f627f490af8975d8c14e9fadf2d7b533a09a7e8c2cc57a4b3563803d7d4eb4db3892337cf233f1f0f154013	1	< 0.1%
57cfcdd70be67a9d66fd973426036aa20034e0f99b695207149cc51002a8c53d7801b1860869929c065660c6f3afa874bb36eb868784218dc931993ba7cd4bf7	1	< 0.1%
1ee2180a89cc02c0b756f95b5b2755bb5cc9d93450f5caafaee5cb5c6aa75adafd251402ac205833ff78be9c9a0eb799f33d9c854975cf3a8e10c6a7d28116c7	1	< 0.1%
61fcb8c1eb522a6469b460e2134df3d15f82e81fd93e9cafd3dc7e631b9e1ba8b450a63af12bd90d1d2d9b127ea287f88d32e138a4eeba17799f536c08048934	1	< 0.1%
004cd14d0303a9163aad69a2d7f341b7da2a8572b2ab3378594bfae8ac53dcb604dd8d414f93c290b55862f9f2517ad32e6209cbc8034c2e26eb3c2bc9724390	1	< 0.1%
a1d5f0ea90897745365a4cbb06cc60329a120d89753fac2b02d69c9685d9cf7c763870a60abd01484a39ed1e6c09b1ba59f38214c03a83cccde1247f794e0287	1	< 0.1%
b236c77d59e32b7b469a6e2f17f438b7457e1bd8bc689b14cb4f5b1590cbe784f2b9e554b41925797251cbd3e93a3f4a131d1923b327673d441ae79c052f79c2	1	< 0.1%
35156ce97cab22747495e92e8bbb16c57e0e60dc3ce6d1f1852f2f7cece07c7ae825b073b286b1da52dfa58082ff6d763ecf1f13f06a223c7aed2b6c1e8c5972	1	< 0.1%
Other values (817713)	817713	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
2	6547788	6.3%
b	6545782	6.3%
d	6545680	6.3%
f	6545495	6.3%
c	6544094	6.3%
9	6542979	6.3%
0	6542034	6.3%
4	6541970	6.3%
8	6541267	6.2%
6	6540678	6.2%
Other values (6)	39230777	37.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	65414221	62.5%
Lowercase Letter	39254323	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	6547788	10.0%
9	6542979	10.0%
0	6542034	10.0%
4	6541970	10.0%
8	6541267	10.0%
6	6540678	10.0%
3	6540426	10.0%
7	6540280	10.0%
5	6539375	10.0%
1	6537424	10.0%

Lowercase Letter

Value	Count	Frequency (%)
b	6545782	16.7%
d	6545680	16.7%
f	6545495	16.7%
c	6544094	16.7%
a	6536722	16.7%
e	6536550	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	65414221	62.5%
Latin	39254323	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	6547788	10.0%
9	6542979	10.0%
0	6542034	10.0%
4	6541970	10.0%
8	6541267	10.0%
6	6540678	10.0%
3	6540426	10.0%
7	6540280	10.0%
5	6539375	10.0%
1	6537424	10.0%

Latin

Value	Count	Frequency (%)
b	6545782	16.7%
d	6545680	16.7%
f	6545495	16.7%
c	6544094	16.7%
a	6536722	16.7%
e	6536550	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	104668544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	6547788	6.3%
b	6545782	6.3%
d	6545680	6.3%
f	6545495	6.3%
c	6544094	6.3%
9	6542979	6.3%
0	6542034	6.3%
4	6541970	6.3%
8	6541267	6.2%
6	6540678	6.2%
Other values (6)	39230777	37.5%

CRASH_DATE_EST_I
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	756594
Missing (%)	92.5%
Memory size	1.6 MiB

True	53267
False	7862
(Missing)	756594

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	53267	6.5%
False	7862	1.0%
(Missing)	756594	92.5%

CRASH_DATE
Date

Distinct	536888
Distinct (%)	65.7%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Minimum	2013-03-03 16:48:00
Maximum	2024-03-26 01:40:00

Histogram

Histogram with fixed size bins (bins=50)

POSTED_SPEED_LIMIT
Real number (ℝ)

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.406041

Minimum	0
Maximum	99
Zeros	7437
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	30
median	30
Q3	30
95-th percentile	35
Maximum	99
Range	99
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.1660655
Coefficient of variation (CV)	0.21706881
Kurtosis	7.6315703
Mean	28.406041
Median Absolute Deviation (MAD)	0
Skewness	-1.8200476
Sum	23228273
Variance	38.020363
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
30	601823	73.6%
35	54652	6.7%
25	51779	6.3%
20	34071	4.2%
15	29084	3.6%
10	19118	2.3%
40	7811	1.0%
0	7437	0.9%
45	5446	0.7%
5	4711	0.6%
Other values (36)	1791	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7437	0.9%
1	41	< 0.1%
2	28	< 0.1%
3	199	< 0.1%
4	2	< 0.1%
5	4711	0.6%
6	7	< 0.1%
7	5	< 0.1%
8	2	< 0.1%
9	96	< 0.1%

Value	Count	Frequency (%)
99	66	< 0.1%
70	6	< 0.1%
65	18	< 0.1%
63	1	< 0.1%
62	1	< 0.1%
60	50	< 0.1%
55	808	0.1%
50	243	< 0.1%
49	1	< 0.1%
46	1	< 0.1%

TRAFFIC_CONTROL_DEVICE
Categorical

IMBALANCE

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

NO CONTROLS	464816
TRAFFIC SIGNAL	226679
STOP SIGN/FLASHER	81158
UNKNOWN	32812
OTHER	5550
Other values (14)	6708

Length

Max length	24
Median length	11
Mean length	12.259755
Min length	5

Characters and Unicode

Total characters	10025084
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OTHER
2nd row	TRAFFIC SIGNAL
3rd row	NO CONTROLS
4th row	NO CONTROLS
5th row	NO CONTROLS

Common Values

Value	Count	Frequency (%)
NO CONTROLS	464816	56.8%
TRAFFIC SIGNAL	226679	27.7%
STOP SIGN/FLASHER	81158	9.9%
UNKNOWN	32812	4.0%
OTHER	5550	0.7%
LANE USE MARKING	1226	0.1%
YIELD	1207	0.1%
OTHER REG. SIGN	908	0.1%
OTHER WARNING SIGN	669	0.1%
RAILROAD CROSSING GATE	532	0.1%
Other values (9)	2166	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
no	464867	29.1%
controls	464816	29.1%
signal	227007	14.2%
traffic	226679	14.2%
stop	81158	5.1%
sign/flasher	81158	5.1%
unknown	32812	2.1%
other	7308	0.5%
sign	2275	0.1%
crossing	1411	0.1%
Other values (18)	10328	0.6%

Most occurring characters

Value	Count	Frequency (%)
O	1520081	15.2%
N	1345892	13.4%
S	943198	9.4%
R	787081	7.9%
	782096	7.8%
T	781661	7.8%
L	777993	7.8%
C	693869	6.9%
I	543866	5.4%
A	541696	5.4%
Other values (15)	1307651	13.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9160645	91.4%
Space Separator	782096	7.8%
Other Punctuation	82343	0.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	1520081	16.6%
N	1345892	14.7%
S	943198	10.3%
R	787081	8.6%
T	781661	8.5%
L	777993	8.5%
C	693869	7.6%
I	543866	5.9%
A	541696	5.9%
F	535121	5.8%
Other values (12)	690187	7.5%

Other Punctuation

Value	Count	Frequency (%)
/	81435	98.9%
.	908	1.1%

Space Separator

Value	Count	Frequency (%)
	782096	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9160645	91.4%
Common	864439	8.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	1520081	16.6%
N	1345892	14.7%
S	943198	10.3%
R	787081	8.6%
T	781661	8.5%
L	777993	8.5%
C	693869	7.6%
I	543866	5.9%
A	541696	5.9%
F	535121	5.8%
Other values (12)	690187	7.5%

Common

Value	Count	Frequency (%)
	782096	90.5%
/	81435	9.4%
.	908	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10025084	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	1520081	15.2%
N	1345892	13.4%
S	943198	9.4%
R	787081	7.9%
	782096	7.8%
T	781661	7.8%
L	777993	7.8%
C	693869	6.9%
I	543866	5.4%
A	541696	5.4%
Other values (15)	1307651	13.0%

DEVICE_CONDITION
Categorical

IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

NO CONTROLS	470240
FUNCTIONING PROPERLY	280006
UNKNOWN	54603
OTHER	6264
FUNCTIONING IMPROPERLY	3849
Other values (3)	2761

Length

Max length	24
Median length	11
Mean length	13.836213
Min length	5

Characters and Unicode

Total characters	11314190
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FUNCTIONING PROPERLY
2nd row	FUNCTIONING PROPERLY
3rd row	NO CONTROLS
4th row	NO CONTROLS
5th row	NO CONTROLS

Common Values

Value	Count	Frequency (%)
NO CONTROLS	470240	57.5%
FUNCTIONING PROPERLY	280006	34.2%
UNKNOWN	54603	6.7%
OTHER	6264	0.8%
FUNCTIONING IMPROPERLY	3849	0.5%
NOT FUNCTIONING	2382	0.3%
WORN REFLECTIVE MATERIAL	284	< 0.1%
MISSING	95	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	470240	29.9%
controls	470240	29.9%
functioning	286237	18.2%
properly	280006	17.8%
unknown	54603	3.5%
other	6264	0.4%
improperly	3849	0.2%
not	2382	0.2%
worn	284	< 0.1%
reflective	284	< 0.1%
Other values (2)	379	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
O	2044345	18.1%
N	1965761	17.4%
R	1045066	9.2%
T	765691	6.8%
	757045	6.7%
C	756761	6.7%
L	754663	6.7%
I	577081	5.1%
P	567710	5.0%
S	470430	4.2%
Other values (11)	1609637	14.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10557145	93.3%
Space Separator	757045	6.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	2044345	19.4%
N	1965761	18.6%
R	1045066	9.9%
T	765691	7.3%
C	756761	7.2%
L	754663	7.1%
I	577081	5.5%
P	567710	5.4%
S	470430	4.5%
U	340840	3.2%
Other values (10)	1268797	12.0%

Space Separator

Value	Count	Frequency (%)
	757045	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10557145	93.3%
Common	757045	6.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	2044345	19.4%
N	1965761	18.6%
R	1045066	9.9%
T	765691	7.3%
C	756761	7.2%
L	754663	7.1%
I	577081	5.5%
P	567710	5.4%
S	470430	4.5%
U	340840	3.2%
Other values (10)	1268797	12.0%

Common

Value	Count	Frequency (%)
	757045	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11314190	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	2044345	18.1%
N	1965761	17.4%
R	1045066	9.2%
T	765691	6.8%
	757045	6.7%
C	756761	6.7%
L	754663	6.7%
I	577081	5.1%
P	567710	5.0%
S	470430	4.2%
Other values (11)	1609637	14.2%

WEATHER_CONDITION
Categorical

HIGH CORRELATION IMBALANCE

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

CLEAR	641373
RAIN	71391
UNKNOWN	45108
SNOW	28352
CLOUDY/OVERCAST	24249
Other values (7)	7250

Length

Max length	24
Median length	5
Mean length	5.3462053
Min length	4

Characters and Unicode

Total characters	4371715
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CLEAR
2nd row	CLEAR
3rd row	CLEAR
4th row	CLEAR
5th row	CLEAR

Common Values

Value	Count	Frequency (%)
CLEAR	641373	78.4%
RAIN	71391	8.7%
UNKNOWN	45108	5.5%
SNOW	28352	3.5%
CLOUDY/OVERCAST	24249	3.0%
OTHER	2601	0.3%
FREEZING RAIN/DRIZZLE	1702	0.2%
FOG/SMOKE/HAZE	1337	0.2%
SLEET/HAIL	1006	0.1%
BLOWING SNOW	444	0.1%
Other values (2)	160	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
clear	641373	78.2%
rain	71391	8.7%
unknown	45108	5.5%
snow	28796	3.5%
cloudy/overcast	24249	3.0%
other	2601	0.3%
freezing	1702	0.2%
rain/drizzle	1702	0.2%
fog/smoke/haze	1337	0.2%
sleet/hail	1006	0.1%
Other values (8)	1084	0.1%

Most occurring characters

Value	Count	Frequency (%)
R	745033	17.0%
A	741218	17.0%
C	690024	15.8%
E	678627	15.5%
L	669794	15.3%
N	239526	5.5%
O	128288	2.9%
I	78121	1.8%
W	74508	1.7%
U	69357	1.6%
Other values (15)	257219	5.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4339444	99.3%
Other Punctuation	29645	0.7%
Space Separator	2626	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	745033	17.2%
A	741218	17.1%
C	690024	15.9%
E	678627	15.6%
L	669794	15.4%
N	239526	5.5%
O	128288	3.0%
I	78121	1.8%
W	74508	1.7%
U	69357	1.6%
Other values (12)	224948	5.2%

Other Punctuation

Value	Count	Frequency (%)
/	29631	> 99.9%
,	14	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2626	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4339444	99.3%
Common	32271	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	745033	17.2%
A	741218	17.1%
C	690024	15.9%
E	678627	15.6%
L	669794	15.4%
N	239526	5.5%
O	128288	3.0%
I	78121	1.8%
W	74508	1.7%
U	69357	1.6%
Other values (12)	224948	5.2%

Common

Value	Count	Frequency (%)
/	29631	91.8%
	2626	8.1%
,	14	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4371715	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	745033	17.0%
A	741218	17.0%
C	690024	15.8%
E	678627	15.5%
L	669794	15.3%
N	239526	5.5%
O	128288	2.9%
I	78121	1.8%
W	74508	1.7%
U	69357	1.6%
Other values (15)	257219	5.9%

LIGHTING_CONDITION
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

DAYLIGHT	522973
DARKNESS, LIGHTED ROAD	181030
DARKNESS	39092
UNKNOWN	37360
DUSK	23579

Length

Max length	22
Median length	8
Mean length	10.871373
Min length	4

Characters and Unicode

Total characters	8889772
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DAYLIGHT
2nd row	DAYLIGHT
3rd row	DAYLIGHT
4th row	DAYLIGHT
5th row	DAYLIGHT

Common Values

Value	Count	Frequency (%)
DAYLIGHT	522973	64.0%
DARKNESS, LIGHTED ROAD	181030	22.1%
DARKNESS	39092	4.8%
UNKNOWN	37360	4.6%
DUSK	23579	2.9%
DAWN	13689	1.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
daylight	522973	44.3%
darkness	220122	18.7%
lighted	181030	15.3%
road	181030	15.3%
unknown	37360	3.2%
dusk	23579	2.0%
dawn	13689	1.2%

Most occurring characters

Value	Count	Frequency (%)
D	1142423	12.9%
A	937814	10.5%
L	704003	7.9%
I	704003	7.9%
G	704003	7.9%
H	704003	7.9%
T	704003	7.9%
Y	522973	5.9%
S	463823	5.2%
R	401152	4.5%
Other values (8)	1901572	21.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8346682	93.9%
Space Separator	362060	4.1%
Other Punctuation	181030	2.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	1142423	13.7%
A	937814	11.2%
L	704003	8.4%
I	704003	8.4%
G	704003	8.4%
H	704003	8.4%
T	704003	8.4%
Y	522973	6.3%
S	463823	5.6%
R	401152	4.8%
Other values (6)	1358482	16.3%

Space Separator

Value	Count	Frequency (%)
	362060	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	181030	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8346682	93.9%
Common	543090	6.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	1142423	13.7%
A	937814	11.2%
L	704003	8.4%
I	704003	8.4%
G	704003	8.4%
H	704003	8.4%
T	704003	8.4%
Y	522973	6.3%
S	463823	5.6%
R	401152	4.8%
Other values (6)	1358482	16.3%

Common

Value	Count	Frequency (%)
	362060	66.7%
,	181030	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8889772	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	1142423	12.9%
A	937814	10.5%
L	704003	7.9%
I	704003	7.9%
G	704003	7.9%
H	704003	7.9%
T	704003	7.9%
Y	522973	5.9%
S	463823	5.2%
R	401152	4.5%
Other values (8)	1901572	21.4%

FIRST_CRASH_TYPE
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

PARKED MOTOR VEHICLE	190062
REAR END	182653
SIDESWIPE SAME DIRECTION	124798
TURNING	116863
ANGLE	88951
Other values (13)	114396

Length

Max length	28
Median length	20
Mean length	13.480296
Min length	5

Characters and Unicode

Total characters	11023148
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	REAR END
2nd row	PARKED MOTOR VEHICLE
3rd row	PEDALCYCLIST
4th row	PEDESTRIAN
5th row	FIXED OBJECT

Common Values

Value	Count	Frequency (%)
PARKED MOTOR VEHICLE	190062	23.2%
REAR END	182653	22.3%
SIDESWIPE SAME DIRECTION	124798	15.3%
TURNING	116863	14.3%
ANGLE	88951	10.9%
FIXED OBJECT	38417	4.7%
PEDESTRIAN	19065	2.3%
PEDALCYCLIST	12307	1.5%
SIDESWIPE OPPOSITE DIRECTION	11529	1.4%
OTHER OBJECT	8102	1.0%
Other values (8)	24976	3.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rear	198570	11.4%
parked	190062	10.9%
motor	190062	10.9%
vehicle	190062	10.9%
end	182653	10.5%
sideswipe	136327	7.8%
direction	136327	7.8%
same	124798	7.2%
turning	116863	6.7%
angle	88951	5.1%
Other values (15)	183121	10.5%

Most occurring characters

Value	Count	Frequency (%)
E	1744409	15.8%
R	1069188	9.7%
I	944043	8.6%
	920073	8.3%
D	727345	6.6%
N	684515	6.2%
A	641957	5.8%
O	634149	5.8%
T	566121	5.1%
S	447634	4.1%
Other values (15)	2643714	24.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10103075	91.7%
Space Separator	920073	8.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1744409	17.3%
R	1069188	10.6%
I	944043	9.3%
D	727345	7.2%
N	684515	6.8%
A	641957	6.4%
O	634149	6.3%
T	566121	5.6%
S	447634	4.4%
C	400100	4.0%
Other values (14)	2243614	22.2%

Space Separator

Value	Count	Frequency (%)
	920073	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10103075	91.7%
Common	920073	8.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1744409	17.3%
R	1069188	10.6%
I	944043	9.3%
D	727345	7.2%
N	684515	6.8%
A	641957	6.4%
O	634149	6.3%
T	566121	5.6%
S	447634	4.4%
C	400100	4.0%
Other values (14)	2243614	22.2%

Common

Value	Count	Frequency (%)
	920073	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11023148	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1744409	15.8%
R	1069188	9.7%
I	944043	8.6%
	920073	8.3%
D	727345	6.6%
N	684515	6.2%
A	641957	5.8%
O	634149	5.8%
T	566121	5.1%
S	447634	4.1%
Other values (15)	2643714	24.0%

TRAFFICWAY_TYPE
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

NOT DIVIDED	355079
DIVIDED - W/MEDIAN (NOT RAISED)	130679
ONE-WAY	104273
PARKING LOT	55690
FOUR WAY	51707
Other values (15)	120295

Length

Max length	31
Median length	11
Mean length	14.145716
Min length	4

Characters and Unicode

Total characters	11567277
Distinct characters	28
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OTHER
2nd row	DIVIDED - W/MEDIAN (NOT RAISED)
3rd row	NOT DIVIDED
4th row	ONE-WAY
5th row	OTHER

Common Values

Value	Count	Frequency (%)
NOT DIVIDED	355079	43.4%
DIVIDED - W/MEDIAN (NOT RAISED)	130679	16.0%
ONE-WAY	104273	12.8%
PARKING LOT	55690	6.8%
FOUR WAY	51707	6.3%
DIVIDED - W/MEDIAN BARRIER	46724	5.7%
OTHER	22378	2.7%
ALLEY	13526	1.7%
T-INTERSECTION	10407	1.3%
UNKNOWN	9520	1.2%
Other values (10)	17740	2.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
divided	532482	27.1%
not	486338	24.8%
	177403	9.0%
w/median	177403	9.0%
raised	130679	6.7%
one-way	104273	5.3%
parking	55690	2.8%
lot	55690	2.8%
four	51707	2.6%
way	51707	2.6%
Other values (22)	141247	7.2%

Most occurring characters

Value	Count	Frequency (%)
D	1909026	16.5%
I	1509514	13.0%
	1146896	9.9%
E	1082853	9.4%
N	906834	7.8%
O	751820	6.5%
T	621099	5.4%
A	592334	5.1%
V	536266	4.6%
R	437333	3.8%
Other values (18)	2073302	17.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9687105	83.7%
Space Separator	1146896	9.9%
Dash Punctuation	293388	2.5%
Other Punctuation	178530	1.5%
Open Punctuation	130679	1.1%
Close Punctuation	130679	1.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	1909026	19.7%
I	1509514	15.6%
E	1082853	11.2%
N	906834	9.4%
O	751820	7.8%
T	621099	6.4%
A	592334	6.1%
V	536266	5.5%
R	437333	4.5%
W	347956	3.6%
Other values (12)	992070	10.2%

Other Punctuation

Value	Count	Frequency (%)
/	177403	99.4%
,	1127	0.6%

Space Separator

Value	Count	Frequency (%)
	1146896	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	293388	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	130679	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	130679	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9687105	83.7%
Common	1880172	16.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	1909026	19.7%
I	1509514	15.6%
E	1082853	11.2%
N	906834	9.4%
O	751820	7.8%
T	621099	6.4%
A	592334	6.1%
V	536266	5.5%
R	437333	4.5%
W	347956	3.6%
Other values (12)	992070	10.2%

Common

Value	Count	Frequency (%)
	1146896	61.0%
-	293388	15.6%
/	177403	9.4%
(	130679	7.0%
)	130679	7.0%
,	1127	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11567277	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	1909026	16.5%
I	1509514	13.0%
	1146896	9.9%
E	1082853	9.4%
N	906834	7.8%
O	751820	6.5%
T	621099	5.4%
A	592334	5.1%
V	536266	4.6%
R	437333	3.8%
Other values (18)	2073302	17.9%

LANE_CNT
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	41
Distinct (%)	< 0.1%
Missing	618714
Missing (%)	75.7%
Infinite	0
Infinite (%)	0.0%
Mean	13.330161

Minimum	0
Maximum	1191625
Zeros	8032
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	4
95-th percentile	4
Maximum	1191625
Range	1191625
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2961.6012
Coefficient of variation (CV)	222.17295
Kurtosis	134678.59
Mean	13.330161
Median Absolute Deviation (MAD)	1
Skewness	350.3036
Sum	2652822
Variance	8771081.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
2	91154	11.1%
4	49588	6.1%
1	32547	4.0%
3	8677	1.1%
0	8032	1.0%
6	4502	0.6%
5	1940	0.2%
8	1908	0.2%
7	184	< 0.1%
10	162	< 0.1%
Other values (31)	315	< 0.1%
(Missing)	618714	75.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8032	1.0%
1	32547	4.0%
2	91154	11.1%
3	8677	1.1%
4	49588	6.1%
5	1940	0.2%
6	4502	0.6%
7	184	< 0.1%
8	1908	0.2%
9	66	< 0.1%

Value	Count	Frequency (%)
1191625	1	< 0.1%
433634	1	< 0.1%
299679	1	< 0.1%
218474	1	< 0.1%
902	1	< 0.1%
400	1	< 0.1%
100	2	< 0.1%
99	108	< 0.1%
80	1	< 0.1%
60	3	< 0.1%

ALIGNMENT
Categorical

IMBALANCE

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

STRAIGHT AND LEVEL	797888
STRAIGHT ON GRADE	10191
CURVE, LEVEL	5904
STRAIGHT ON HILLCREST	2145
CURVE ON GRADE	1231

Length

Max length	21
Median length	18
Mean length	17.946065
Min length	12

Characters and Unicode

Total characters	14674910
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	STRAIGHT AND LEVEL
2nd row	STRAIGHT AND LEVEL
3rd row	STRAIGHT AND LEVEL
4th row	CURVE ON GRADE
5th row	STRAIGHT AND LEVEL

Common Values

Value	Count	Frequency (%)
STRAIGHT AND LEVEL	797888	97.6%
STRAIGHT ON GRADE	10191	1.2%
CURVE, LEVEL	5904	0.7%
STRAIGHT ON HILLCREST	2145	0.3%
CURVE ON GRADE	1231	0.2%
CURVE ON HILLCREST	364	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
straight	810224	33.1%
level	803792	32.8%
and	797888	32.6%
on	13931	0.6%
grade	11422	0.5%
curve	7499	0.3%
hillcrest	2509	0.1%

Most occurring characters

Value	Count	Frequency (%)
	1629542	11.1%
E	1629014	11.1%
T	1622957	11.1%
A	1619534	11.0%
L	1612602	11.0%
R	831654	5.7%
G	821646	5.6%
S	812733	5.5%
I	812733	5.5%
H	812733	5.5%
Other values (7)	2469762	16.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	13039464	88.9%
Space Separator	1629542	11.1%
Other Punctuation	5904	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1629014	12.5%
T	1622957	12.4%
A	1619534	12.4%
L	1612602	12.4%
R	831654	6.4%
G	821646	6.3%
S	812733	6.2%
I	812733	6.2%
H	812733	6.2%
N	811819	6.2%
Other values (5)	1652039	12.7%

Space Separator

Value	Count	Frequency (%)
	1629542	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	5904	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13039464	88.9%
Common	1635446	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1629014	12.5%
T	1622957	12.4%
A	1619534	12.4%
L	1612602	12.4%
R	831654	6.4%
G	821646	6.3%
S	812733	6.2%
I	812733	6.2%
H	812733	6.2%
N	811819	6.2%
Other values (5)	1652039	12.7%

Common

Value	Count	Frequency (%)
	1629542	99.6%
,	5904	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14674910	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1629542	11.1%
E	1629014	11.1%
T	1622957	11.1%
A	1619534	11.0%
L	1612602	11.0%
R	831654	5.7%
G	821646	5.6%
S	812733	5.5%
I	812733	5.5%
H	812733	5.5%
Other values (7)	2469762	16.8%

ROADWAY_SURFACE_COND
Categorical

HIGH CORRELATION IMBALANCE

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

DRY	603295
WET	108880
UNKNOWN	69415
SNOW OR SLUSH	28111
ICE	5658
Other values (2)	2364

Length

Max length	15
Median length	3
Mean length	3.6928116
Min length	3

Characters and Unicode

Total characters	3019697
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DRY
2nd row	DRY
3rd row	DRY
4th row	DRY
5th row	DRY

Common Values

Value	Count	Frequency (%)
DRY	603295	73.8%
WET	108880	13.3%
UNKNOWN	69415	8.5%
SNOW OR SLUSH	28111	3.4%
ICE	5658	0.7%
OTHER	2061	0.3%
SAND, MUD, DIRT	303	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dry	603295	69.0%
wet	108880	12.4%
unknown	69415	7.9%
snow	28111	3.2%
or	28111	3.2%
slush	28111	3.2%
ice	5658	0.6%
other	2061	0.2%
sand	303	< 0.1%
mud	303	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
R	633770	21.0%
D	604204	20.0%
Y	603295	20.0%
N	236659	7.8%
W	206406	6.8%
O	127698	4.2%
E	116599	3.9%
T	111244	3.7%
U	97829	3.2%
S	84636	2.8%
Other values (9)	197357	6.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2962263	98.1%
Space Separator	56828	1.9%
Other Punctuation	606	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	633770	21.4%
D	604204	20.4%
Y	603295	20.4%
N	236659	8.0%
W	206406	7.0%
O	127698	4.3%
E	116599	3.9%
T	111244	3.8%
U	97829	3.3%
S	84636	2.9%
Other values (7)	139923	4.7%

Space Separator

Value	Count	Frequency (%)
	56828	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	606	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2962263	98.1%
Common	57434	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	633770	21.4%
D	604204	20.4%
Y	603295	20.4%
N	236659	8.0%
W	206406	7.0%
O	127698	4.3%
E	116599	3.9%
T	111244	3.8%
U	97829	3.3%
S	84636	2.9%
Other values (7)	139923	4.7%

Common

Value	Count	Frequency (%)
	56828	98.9%
,	606	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3019697	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	633770	21.0%
D	604204	20.0%
Y	603295	20.0%
N	236659	7.8%
W	206406	6.8%
O	127698	4.2%
E	116599	3.9%
T	111244	3.7%
U	97829	3.2%
S	84636	2.8%
Other values (9)	197357	6.5%

ROAD_DEFECT
Categorical

IMBALANCE

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

NO DEFECTS	657425
UNKNOWN	144337
RUT, HOLES	6056
OTHER	4458
WORN SURFACE	3356
Other values (2)	2091

Length

Max length	17
Median length	10
Mean length	9.465709
Min length	5

Characters and Unicode

Total characters	7740328
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NO DEFECTS
2nd row	NO DEFECTS
3rd row	NO DEFECTS
4th row	NO DEFECTS
5th row	NO DEFECTS

Common Values

Value	Count	Frequency (%)
NO DEFECTS	657425	80.4%
UNKNOWN	144337	17.7%
RUT, HOLES	6056	0.7%
OTHER	4458	0.5%
WORN SURFACE	3356	0.4%
SHOULDER DEFECT	1475	0.2%
DEBRIS ON ROADWAY	616	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	657425	44.2%
defects	657425	44.2%
unknown	144337	9.7%
rut	6056	0.4%
holes	6056	0.4%
other	4458	0.3%
worn	3356	0.2%
surface	3356	0.2%
shoulder	1475	0.1%
defect	1475	0.1%
Other values (3)	1848	0.1%

Most occurring characters

Value	Count	Frequency (%)
E	1333761	17.2%
N	1094408	14.1%
O	818339	10.6%
	669544	8.7%
T	669414	8.6%
S	668928	8.6%
F	662256	8.6%
C	662256	8.6%
D	661607	8.5%
U	155224	2.0%
Other values (10)	344591	4.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7064728	91.3%
Space Separator	669544	8.7%
Other Punctuation	6056	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1333761	18.9%
N	1094408	15.5%
O	818339	11.6%
T	669414	9.5%
S	668928	9.5%
F	662256	9.4%
C	662256	9.4%
D	661607	9.4%
U	155224	2.2%
W	148309	2.1%
Other values (8)	190226	2.7%

Space Separator

Value	Count	Frequency (%)
	669544	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	6056	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7064728	91.3%
Common	675600	8.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1333761	18.9%
N	1094408	15.5%
O	818339	11.6%
T	669414	9.5%
S	668928	9.5%
F	662256	9.4%
C	662256	9.4%
D	661607	9.4%
U	155224	2.2%
W	148309	2.1%
Other values (8)	190226	2.7%

Common

Value	Count	Frequency (%)
	669544	99.1%
,	6056	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7740328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1333761	17.2%
N	1094408	14.1%
O	818339	10.6%
	669544	8.7%
T	669414	8.6%
S	668928	8.6%
F	662256	8.6%
C	662256	8.6%
D	661607	8.5%
U	155224	2.0%
Other values (10)	344591	4.5%

REPORT_TYPE
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	24314
Missing (%)	3.0%
Memory size	6.2 MiB

NOT ON SCENE (DESK REPORT)	447696
ON SCENE	345473
AMENDED	240

Length

Max length	26
Median length	26
Mean length	18.156537
Min length	7

Characters and Unicode

Total characters	14405560
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ON SCENE
2nd row	ON SCENE
3rd row	ON SCENE
4th row	ON SCENE
5th row	ON SCENE

Common Values

Value	Count	Frequency (%)
NOT ON SCENE (DESK REPORT)	447696	54.7%
ON SCENE	345473	42.2%
AMENDED	240	< 0.1%
(Missing)	24314	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
on	793169	27.1%
scene	793169	27.1%
not	447696	15.3%
desk	447696	15.3%
report	447696	15.3%
amended	240	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	2482210	17.2%
	2136257	14.8%
N	2034274	14.1%
O	1688561	11.7%
S	1240865	8.6%
T	895392	6.2%
R	895392	6.2%
C	793169	5.5%
D	448176	3.1%
(	447696	3.1%
Other values (5)	1343568	9.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11373911	79.0%
Space Separator	2136257	14.8%
Open Punctuation	447696	3.1%
Close Punctuation	447696	3.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	2482210	21.8%
N	2034274	17.9%
O	1688561	14.8%
S	1240865	10.9%
T	895392	7.9%
R	895392	7.9%
C	793169	7.0%
D	448176	3.9%
K	447696	3.9%
P	447696	3.9%
Other values (2)	480	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2136257	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	447696	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	447696	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11373911	79.0%
Common	3031649	21.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	2482210	21.8%
N	2034274	17.9%
O	1688561	14.8%
S	1240865	10.9%
T	895392	7.9%
R	895392	7.9%
C	793169	7.0%
D	448176	3.9%
K	447696	3.9%
P	447696	3.9%
Other values (2)	480	< 0.1%

Common

Value	Count	Frequency (%)
	2136257	70.5%
(	447696	14.8%
)	447696	14.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14405560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	2482210	17.2%
	2136257	14.8%
N	2034274	14.1%
O	1688561	11.7%
S	1240865	8.6%
T	895392	6.2%
R	895392	6.2%
C	793169	5.5%
D	448176	3.1%
(	447696	3.1%
Other values (5)	1343568	9.3%

CRASH_TYPE
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

NO INJURY / DRIVE AWAY	599383
INJURY AND / OR TOW DUE TO CRASH	218340

Length

Max length	32
Median length	22
Mean length	24.670097
Min length	22

Characters and Unicode

Total characters	20173306
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INJURY AND / OR TOW DUE TO CRASH
2nd row	NO INJURY / DRIVE AWAY
3rd row	INJURY AND / OR TOW DUE TO CRASH
4th row	INJURY AND / OR TOW DUE TO CRASH
5th row	NO INJURY / DRIVE AWAY

Common Values

Value	Count	Frequency (%)
NO INJURY / DRIVE AWAY	599383	73.3%
INJURY AND / OR TOW DUE TO CRASH	218340	26.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
injury	817723	17.2%
	817723	17.2%
no	599383	12.6%
drive	599383	12.6%
away	599383	12.6%
and	218340	4.6%
or	218340	4.6%
tow	218340	4.6%
due	218340	4.6%
to	218340	4.6%

Most occurring characters

Value	Count	Frequency (%)
	3925912	19.5%
R	1853786	9.2%
N	1635446	8.1%
A	1635446	8.1%
Y	1417106	7.0%
I	1417106	7.0%
O	1254403	6.2%
D	1036063	5.1%
U	1036063	5.1%
/	817723	4.1%
Other values (8)	4144252	20.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	15429671	76.5%
Space Separator	3925912	19.5%
Other Punctuation	817723	4.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	1853786	12.0%
N	1635446	10.6%
A	1635446	10.6%
Y	1417106	9.2%
I	1417106	9.2%
O	1254403	8.1%
D	1036063	6.7%
U	1036063	6.7%
E	817723	5.3%
J	817723	5.3%
Other values (6)	2508806	16.3%

Space Separator

Value	Count	Frequency (%)
	3925912	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	817723	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15429671	76.5%
Common	4743635	23.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	1853786	12.0%
N	1635446	10.6%
A	1635446	10.6%
Y	1417106	9.2%
I	1417106	9.2%
O	1254403	8.1%
D	1036063	6.7%
U	1036063	6.7%
E	817723	5.3%
J	817723	5.3%
Other values (6)	2508806	16.3%

Common

Value	Count	Frequency (%)
	3925912	82.8%
/	817723	17.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20173306	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3925912	19.5%
R	1853786	9.2%
N	1635446	8.1%
A	1635446	8.1%
Y	1417106	7.0%
I	1417106	7.0%
O	1254403	6.2%
D	1036063	5.1%
U	1036063	5.1%
/	817723	4.1%
Other values (8)	4144252	20.5%

INTERSECTION_RELATED_I
Boolean

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	630174
Missing (%)	77.1%
Memory size	1.6 MiB

True	178642
False	8907
(Missing)	630174

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	178642	21.8%
False	8907	1.1%
(Missing)	630174	77.1%

NOT_RIGHT_OF_WAY_I
Boolean

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	780015
Missing (%)	95.4%
Memory size	1.6 MiB

True	34256
False	3452
(Missing)	780015

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	34256	4.2%
False	3452	0.4%
(Missing)	780015	95.4%

HIT_AND_RUN_I
Boolean

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	561774
Missing (%)	68.7%
Memory size	1.6 MiB

True	244955
False	10994
(Missing)	561774

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	244955	30.0%
False	10994	1.3%
(Missing)	561774	68.7%

DAMAGE
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

OVER $1,500	507718
$501 - $1,500	216632
$500 OR LESS	93373

Length

Max length	13
Median length	11
Mean length	11.644029
Min length	11

Characters and Unicode

Total characters	9521590
Distinct characters	13
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OVER $1,500
2nd row	OVER $1,500
3rd row	$501 - $1,500
4th row	OVER $1,500
5th row	OVER $1,500

Common Values

Value	Count	Frequency (%)
OVER $1,500	507718	62.1%
$501 - $1,500	216632	26.5%
$500 OR LESS	93373	11.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1,500	724350	37.2%
over	507718	26.1%
501	216632	11.1%
	216632	11.1%
500	93373	4.8%
or	93373	4.8%
less	93373	4.8%

Most occurring characters

Value	Count	Frequency (%)
0	1852078	19.5%
	1127728	11.8%
$	1034355	10.9%
5	1034355	10.9%
1	940982	9.9%
,	724350	7.6%
O	601091	6.3%
E	601091	6.3%
R	601091	6.3%
V	507718	5.3%
Other values (3)	496751	5.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3827415	40.2%
Uppercase Letter	2591110	27.2%
Space Separator	1127728	11.8%
Currency Symbol	1034355	10.9%
Other Punctuation	724350	7.6%
Dash Punctuation	216632	2.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	601091	23.2%
E	601091	23.2%
R	601091	23.2%
V	507718	19.6%
S	186746	7.2%
L	93373	3.6%

Decimal Number

Value	Count	Frequency (%)
0	1852078	48.4%
5	1034355	27.0%
1	940982	24.6%

Space Separator

Value	Count	Frequency (%)
	1127728	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1034355	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	724350	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	216632	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6930480	72.8%
Latin	2591110	27.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1852078	26.7%
	1127728	16.3%
$	1034355	14.9%
5	1034355	14.9%
1	940982	13.6%
,	724350	10.5%
-	216632	3.1%

Latin

Value	Count	Frequency (%)
O	601091	23.2%
E	601091	23.2%
R	601091	23.2%
V	507718	19.6%
S	186746	7.2%
L	93373	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9521590	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1852078	19.5%
	1127728	11.8%
$	1034355	10.9%
5	1034355	10.9%
1	940982	9.9%
,	724350	7.6%
O	601091	6.3%
E	601091	6.3%
R	601091	6.3%
V	507718	5.3%
Other values (3)	496751	5.2%

DATE_POLICE_NOTIFIED
Date

Distinct	620545
Distinct (%)	75.9%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

Minimum	2013-06-01 20:31:00
Maximum	2024-03-26 01:42:00

Histogram

Histogram with fixed size bins (bins=50)

PRIM_CONTRIBUTORY_CAUSE
Categorical

Distinct	40
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

UNABLE TO DETERMINE	318311
FAILING TO YIELD RIGHT-OF-WAY	89872
FOLLOWING TOO CLOSELY	79457
NOT APPLICABLE	43275
IMPROPER OVERTAKING/PASSING	40275
Other values (35)	246533

Length

Max length	80
Median length	75
Mean length	23.717536
Min length	6

Characters and Unicode

Total characters	19394375
Distinct characters	33
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FOLLOWING TOO CLOSELY
2nd row	FAILING TO REDUCE SPEED TO AVOID CRASH
3rd row	FAILING TO REDUCE SPEED TO AVOID CRASH
4th row	UNABLE TO DETERMINE
5th row	FOLLOWING TOO CLOSELY

Common Values

Value	Count	Frequency (%)
UNABLE TO DETERMINE	318311	38.9%
FAILING TO YIELD RIGHT-OF-WAY	89872	11.0%
FOLLOWING TOO CLOSELY	79457	9.7%
NOT APPLICABLE	43275	5.3%
IMPROPER OVERTAKING/PASSING	40275	4.9%
FAILING TO REDUCE SPEED TO AVOID CRASH	34546	4.2%
IMPROPER BACKING	32183	3.9%
IMPROPER LANE USAGE	29304	3.6%
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	27355	3.3%
IMPROPER TURNING/NO SIGNAL	27176	3.3%
Other values (30)	95969	11.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
to	479178	17.8%
unable	318311	11.8%
determine	318311	11.8%
improper	128938	4.8%
failing	124418	4.6%
yield	90143	3.4%
right-of-way	89872	3.3%
closely	79457	3.0%
too	79457	3.0%
following	79457	3.0%
Other values (106)	902641	33.6%

Most occurring characters

Value	Count	Frequency (%)
E	2379311	12.3%
	1872460	9.7%
I	1640913	8.5%
N	1463185	7.5%
O	1408342	7.3%
T	1236970	6.4%
L	1181395	6.1%
R	1119969	5.8%
A	1068916	5.5%
G	720628	3.7%
Other values (23)	5302286	27.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	17118096	88.3%
Space Separator	1872460	9.7%
Dash Punctuation	194178	1.0%
Other Punctuation	190155	1.0%
Open Punctuation	9743	0.1%
Close Punctuation	9743	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	2379311	13.9%
I	1640913	9.6%
N	1463185	8.5%
O	1408342	8.2%
T	1236970	7.2%
L	1181395	6.9%
R	1119969	6.5%
A	1068916	6.2%
G	720628	4.2%
D	709927	4.1%
Other values (16)	4188540	24.5%

Other Punctuation

Value	Count	Frequency (%)
/	136150	71.6%
,	48963	25.7%
.	5042	2.7%

Space Separator

Value	Count	Frequency (%)
	1872460	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	194178	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	9743	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	9743	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17118096	88.3%
Common	2276279	11.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	2379311	13.9%
I	1640913	9.6%
N	1463185	8.5%
O	1408342	8.2%
T	1236970	7.2%
L	1181395	6.9%
R	1119969	6.5%
A	1068916	6.2%
G	720628	4.2%
D	709927	4.1%
Other values (16)	4188540	24.5%

Common

Value	Count	Frequency (%)
	1872460	82.3%
-	194178	8.5%
/	136150	6.0%
,	48963	2.2%
(	9743	0.4%
)	9743	0.4%
.	5042	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19394375	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	2379311	12.3%
	1872460	9.7%
I	1640913	8.5%
N	1463185	7.5%
O	1408342	7.3%
T	1236970	6.4%
L	1181395	6.1%
R	1119969	5.8%
A	1068916	5.5%
G	720628	3.7%
Other values (23)	5302286	27.3%

SEC_CONTRIBUTORY_CAUSE
Categorical

IMBALANCE

Distinct	40
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.2 MiB

NOT APPLICABLE	335814
UNABLE TO DETERMINE	295746
FAILING TO REDUCE SPEED TO AVOID CRASH	30501
FAILING TO YIELD RIGHT-OF-WAY	25722
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	25124
Other values (35)	104816

Length

Max length	80
Median length	75
Mean length	19.476758
Min length	6

Characters and Unicode

Total characters	15926593
Distinct characters	33
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DISTRACTION - FROM INSIDE VEHICLE
2nd row	OPERATING VEHICLE IN ERRATIC, RECKLESS, CARELESS, NEGLIGENT OR AGGRESSIVE MANNER
3rd row	UNABLE TO DETERMINE
4th row	NOT APPLICABLE
5th row	DRIVING SKILLS/KNOWLEDGE/EXPERIENCE

Common Values

Value	Count	Frequency (%)
NOT APPLICABLE	335814	41.1%
UNABLE TO DETERMINE	295746	36.2%
FAILING TO REDUCE SPEED TO AVOID CRASH	30501	3.7%
FAILING TO YIELD RIGHT-OF-WAY	25722	3.1%
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	25124	3.1%
FOLLOWING TOO CLOSELY	21547	2.6%
IMPROPER OVERTAKING/PASSING	12508	1.5%
IMPROPER LANE USAGE	11477	1.4%
WEATHER	9434	1.2%
IMPROPER TURNING/NO SIGNAL	8350	1.0%
Other values (30)	41500	5.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
to	383293	16.7%
not	336812	14.7%
applicable	335814	14.7%
unable	295746	12.9%
determine	295746	12.9%
failing	56223	2.5%
improper	38903	1.7%
speed	33412	1.5%
reduce	30501	1.3%
avoid	30501	1.3%
Other values (106)	451894	19.7%

Most occurring characters

Value	Count	Frequency (%)
E	2092865	13.1%
	1471122	9.2%
L	1277925	8.0%
N	1264704	7.9%
A	1252400	7.9%
I	1174220	7.4%
T	1157151	7.3%
O	1032677	6.5%
P	833672	5.2%
B	648046	4.1%
Other values (23)	3721811	23.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	14284061	89.7%
Space Separator	1471122	9.2%
Other Punctuation	103974	0.7%
Dash Punctuation	57156	0.4%
Open Punctuation	5140	< 0.1%
Close Punctuation	5140	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	2092865	14.7%
L	1277925	8.9%
N	1264704	8.9%
A	1252400	8.8%
I	1174220	8.2%
T	1157151	8.1%
O	1032677	7.2%
P	833672	5.8%
B	648046	4.5%
R	646823	4.5%
Other values (16)	2903578	20.3%

Other Punctuation

Value	Count	Frequency (%)
/	76673	73.7%
,	24499	23.6%
.	2802	2.7%

Space Separator

Value	Count	Frequency (%)
	1471122	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	57156	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	5140	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5140	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14284061	89.7%
Common	1642532	10.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	2092865	14.7%
L	1277925	8.9%
N	1264704	8.9%
A	1252400	8.8%
I	1174220	8.2%
T	1157151	8.1%
O	1032677	7.2%
P	833672	5.8%
B	648046	4.5%
R	646823	4.5%
Other values (16)	2903578	20.3%

Common

Value	Count	Frequency (%)
	1471122	89.6%
/	76673	4.7%
-	57156	3.5%
,	24499	1.5%
(	5140	0.3%
)	5140	0.3%
.	2802	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15926593	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	2092865	13.1%
	1471122	9.2%
L	1277925	8.0%
N	1264704	7.9%
A	1252400	7.9%
I	1174220	7.4%
T	1157151	7.3%
O	1032677	6.5%
P	833672	5.2%
B	648046	4.1%
Other values (23)	3721811	23.4%

STREET_NO
Real number (ℝ)

HIGH CORRELATION

Distinct	11728
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3689.6337

Minimum	0
Maximum	451100
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	150
Q1	1250
median	3201
Q3	5600
95-th percentile	9041
Maximum	451100
Range	451100
Interquartile range (IQR)	4350

Descriptive statistics

Standard deviation	2886.8844
Coefficient of variation (CV)	0.78243115
Kurtosis	705.36663
Mean	3689.6337
Median Absolute Deviation (MAD)	2101
Skewness	5.2745308
Sum	3.0170984 × 10⁹
Variance	8334101.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1600	5262	0.6%
100	4886	0.6%
800	4779	0.6%
200	4525	0.6%
300	4114	0.5%
2400	3998	0.5%
4700	3997	0.5%
1200	3927	0.5%
500	3924	0.5%
6300	3796	0.5%
Other values (11718)	774515	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	< 0.1%
1	3418	0.4%
2	1660	0.2%
3	667	0.1%
4	144	< 0.1%
5	599	0.1%
6	202	< 0.1%
7	166	< 0.1%
8	194	< 0.1%
9	175	< 0.1%

Value	Count	Frequency (%)
451100	1	< 0.1%
34453	1	< 0.1%
13799	5	< 0.1%
13795	1	< 0.1%
13787	1	< 0.1%
13781	1	< 0.1%
13780	1	< 0.1%
13770	27	< 0.1%
13768	1	< 0.1%
13763	1	< 0.1%

STREET_DIRECTION
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	6.2 MiB

W	292260
S	273919
N	195919
E	55621

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	817719
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	W
2nd row	S
3rd row	N
4th row	W
5th row	W

Common Values

Value	Count	Frequency (%)
W	292260	35.7%
S	273919	33.5%
N	195919	24.0%
E	55621	6.8%
(Missing)	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
w	292260	35.7%
s	273919	33.5%
n	195919	24.0%
e	55621	6.8%

Most occurring characters

Value	Count	Frequency (%)
W	292260	35.7%
S	273919	33.5%
N	195919	24.0%
E	55621	6.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	817719	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	292260	35.7%
S	273919	33.5%
N	195919	24.0%
E	55621	6.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	817719	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	292260	35.7%
S	273919	33.5%
N	195919	24.0%
E	55621	6.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	817719	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	292260	35.7%
S	273919	33.5%
N	195919	24.0%
E	55621	6.8%

STREET_NAME
Text

Distinct	1641
Distinct (%)	0.2%
Missing	1
Missing (%)	< 0.1%
Memory size	6.2 MiB

Length

Max length	31
Median length	24
Mean length	10.678632
Min length	4

Characters and Unicode

Total characters	8732152
Distinct characters	40
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	141 ?
Unique (%)	< 0.1%

Sample

1st row	OHARE ST
2nd row	ASHLAND AVE
3rd row	LONG AVE
4th row	TERMINAL ST
5th row	TERMINAL ST

Value	Count	Frequency (%)
ave	414428	23.7%
st	254107	14.5%
rd	52778	3.0%
dr	50039	2.9%
blvd	31182	1.8%
lake	26020	1.5%
western	23756	1.4%
shore	21868	1.3%
pulaski	19695	1.1%
cicero	18335	1.0%
Other values (1344)	835757	47.8%

Most occurring characters

Value	Count	Frequency (%)
E	1000603	11.5%
A	953307	10.9%
	930244	10.7%
T	620128	7.1%
S	576159	6.6%
R	559100	6.4%
V	506123	5.8%
N	438388	5.0%
L	407720	4.7%
O	365313	4.2%
Other values (30)	2375067	27.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7563836	86.6%
Space Separator	930244	10.7%
Decimal Number	238066	2.7%
Other Punctuation	5	< 0.1%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1000603	13.2%
A	953307	12.6%
T	620128	8.2%
S	576159	7.6%
R	559100	7.4%
V	506123	6.7%
N	438388	5.8%
L	407720	5.4%
O	365313	4.8%
D	353941	4.7%
Other values (16)	1783054	23.6%

Decimal Number

Value	Count	Frequency (%)
1	42005	17.6%
7	38094	16.0%
5	29165	12.3%
3	26585	11.2%
9	23906	10.0%
6	23153	9.7%
8	18924	7.9%
4	14363	6.0%
0	11495	4.8%
2	10376	4.4%

Other Punctuation

Value	Count	Frequency (%)
/	3	60.0%
.	2	40.0%

Space Separator

Value	Count	Frequency (%)
	930244	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7563836	86.6%
Common	1168316	13.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1000603	13.2%
A	953307	12.6%
T	620128	8.2%
S	576159	7.6%
R	559100	7.4%
V	506123	6.7%
N	438388	5.8%
L	407720	5.4%
O	365313	4.8%
D	353941	4.7%
Other values (16)	1783054	23.6%

Common

Value	Count	Frequency (%)
	930244	79.6%
1	42005	3.6%
7	38094	3.3%
5	29165	2.5%
3	26585	2.3%
9	23906	2.0%
6	23153	2.0%
8	18924	1.6%
4	14363	1.2%
0	11495	1.0%
Other values (4)	10382	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8732152	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1000603	11.5%
A	953307	10.9%
	930244	10.7%
T	620128	7.1%
S	576159	6.6%
R	559100	6.4%
V	506123	5.8%
N	438388	5.0%
L	407720	4.7%
O	365313	4.2%
Other values (30)	2375067	27.2%

BEAT_OF_OCCURRENCE
Real number (ℝ)

HIGH CORRELATION

Distinct	276
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1243.7345

Minimum	111
Maximum	6100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	111
5-th percentile	131
Q1	714
median	1212
Q3	1822
95-th percentile	2513
Maximum	6100
Range	5989
Interquartile range (IQR)	1108

Descriptive statistics

Standard deviation	705.2713
Coefficient of variation (CV)	0.56705936
Kurtosis	-0.99710383
Mean	1243.7345
Median Absolute Deviation (MAD)	580
Skewness	0.17926577
Sum	1.0170241 × 10⁹
Variance	497407.61
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1834	9942	1.2%
114	8369	1.0%
813	8217	1.0%
815	7798	1.0%
1831	7587	0.9%
122	7159	0.9%
833	6721	0.8%
834	6215	0.8%
2413	6142	0.8%
2512	6007	0.7%
Other values (266)	743561	90.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
111	3557	0.4%
112	2497	0.3%
113	1908	0.2%
114	8369	1.0%
121	3831	0.5%
122	7159	0.9%
123	4979	0.6%
124	4277	0.5%
131	4862	0.6%
132	4970	0.6%

Value	Count	Frequency (%)
6100	4	< 0.1%
2535	2598	0.3%
2534	3472	0.4%
2533	5774	0.7%
2532	2293	0.3%
2531	2200	0.3%
2525	1791	0.2%
2524	2583	0.3%
2523	2860	0.3%
2522	3418	0.4%

PHOTOS_TAKEN_I
Boolean

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	806948
Missing (%)	98.7%
Memory size	1.6 MiB

True	8110
False	2665
(Missing)	806948

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	8110	1.0%
False	2665	0.3%
(Missing)	806948	98.7%

STATEMENTS_TAKEN_I
Boolean

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	799465
Missing (%)	97.8%
Memory size	1.6 MiB

True	14874
False	3384
(Missing)	799465

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	14874	1.8%
False	3384	0.4%
(Missing)	799465	97.8%

DOORING_I
Boolean

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	815211
Missing (%)	99.7%
Memory size	1.6 MiB

True	1688
False	824
(Missing)	815211

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	1688	0.2%
False	824	0.1%
(Missing)	815211	99.7%

WORK_ZONE_I
Boolean

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	813053
Missing (%)	99.4%
Memory size	1.6 MiB

True	3618
False	1052
(Missing)	813053

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3618	0.4%
False	1052	0.1%
(Missing)	813053	99.4%

WORK_ZONE_TYPE
Categorical

HIGH CORRELATION MISSING

Distinct	4
Distinct (%)	0.1%
Missing	814105
Missing (%)	99.6%
Memory size	6.2 MiB

CONSTRUCTION	2506
UNKNOWN	514
MAINTENANCE	370
UTILITY	228

Length

Max length	12
Median length	12
Mean length	10.872305
Min length	7

Characters and Unicode

Total characters	39336
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CONSTRUCTION
2nd row	CONSTRUCTION
3rd row	CONSTRUCTION
4th row	CONSTRUCTION
5th row	CONSTRUCTION

Common Values

Value	Count	Frequency (%)
CONSTRUCTION	2506	0.3%
UNKNOWN	514	0.1%
MAINTENANCE	370	< 0.1%
UTILITY	228	< 0.1%
(Missing)	814105	99.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
construction	2506	69.3%
unknown	514	14.2%
maintenance	370	10.2%
utility	228	6.3%

Most occurring characters

Value	Count	Frequency (%)
N	7664	19.5%
T	5838	14.8%
O	5526	14.0%
C	5382	13.7%
I	3332	8.5%
U	3248	8.3%
S	2506	6.4%
R	2506	6.4%
A	740	1.9%
E	740	1.9%
Other values (5)	1854	4.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	39336	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	7664	19.5%
T	5838	14.8%
O	5526	14.0%
C	5382	13.7%
I	3332	8.5%
U	3248	8.3%
S	2506	6.4%
R	2506	6.4%
A	740	1.9%
E	740	1.9%
Other values (5)	1854	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39336	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	7664	19.5%
T	5838	14.8%
O	5526	14.0%
C	5382	13.7%
I	3332	8.5%
U	3248	8.3%
S	2506	6.4%
R	2506	6.4%
A	740	1.9%
E	740	1.9%
Other values (5)	1854	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39336	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	7664	19.5%
T	5838	14.8%
O	5526	14.0%
C	5382	13.7%
I	3332	8.5%
U	3248	8.3%
S	2506	6.4%
R	2506	6.4%
A	740	1.9%
E	740	1.9%
Other values (5)	1854	4.7%

WORKERS_PRESENT_I
Boolean

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.2%
Missing	816529
Missing (%)	99.9%
Memory size	1.6 MiB

True	1056
False	138
(Missing)	816529

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	1056	0.1%
False	138	< 0.1%
(Missing)	816529	99.9%

NUM_UNITS
Real number (ℝ)

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0349189

Minimum	1
Maximum	18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	18
Range	17
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.45282316
Coefficient of variation (CV)	0.22252639
Kurtosis	38.099939
Mean	2.0349189
Median Absolute Deviation (MAD)	0
Skewness	3.3280078
Sum	1664000
Variance	0.20504881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
2	715414	87.5%
3	45230	5.5%
1	45221	5.5%
4	8745	1.1%
5	2130	0.3%
6	603	0.1%
7	210	< 0.1%
8	95	< 0.1%
9	38	< 0.1%
10	16	< 0.1%
Other values (7)	21	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	45221	5.5%
2	715414	87.5%
3	45230	5.5%
4	8745	1.1%
5	2130	0.3%
6	603	0.1%
7	210	< 0.1%
8	95	< 0.1%
9	38	< 0.1%
10	16	< 0.1%

Value	Count	Frequency (%)
18	4	< 0.1%
16	1	< 0.1%
15	1	< 0.1%
14	2	< 0.1%
13	1	< 0.1%
12	5	< 0.1%
11	7	< 0.1%
10	16	< 0.1%
9	38	< 0.1%
8	95	< 0.1%

MOST_SEVERE_INJURY
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	1792
Missing (%)	0.2%
Memory size	6.2 MiB

NO INDICATION OF INJURY	703419
NONINCAPACITATING INJURY	63461
REPORTED, NOT EVIDENT	34331
INCAPACITATING INJURY	13821
FATAL	899

Length

Max length	24
Median length	23
Mean length	22.939915
Min length	5

Characters and Unicode

Total characters	18717388
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NONINCAPACITATING INJURY
2nd row	NO INDICATION OF INJURY
3rd row	NONINCAPACITATING INJURY
4th row	FATAL
5th row	NO INDICATION OF INJURY

Common Values

Value	Count	Frequency (%)
NO INDICATION OF INJURY	703419	86.0%
NONINCAPACITATING INJURY	63461	7.8%
REPORTED, NOT EVIDENT	34331	4.2%
INCAPACITATING INJURY	13821	1.7%
FATAL	899	0.1%
(Missing)	1792	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
injury	780701	25.4%
no	703419	22.9%
indication	703419	22.9%
of	703419	22.9%
nonincapacitating	63461	2.1%
reported	34331	1.1%
not	34331	1.1%
evident	34331	1.1%
incapacitating	13821	0.4%
fatal	899	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	3241106	17.3%
I	3157135	16.9%
	2256201	12.1%
O	2242380	12.0%
T	961875	5.1%
A	937063	5.0%
C	857983	4.6%
R	849363	4.5%
U	780701	4.2%
Y	780701	4.2%
Other values (9)	2652880	14.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16426856	87.8%
Space Separator	2256201	12.1%
Other Punctuation	34331	0.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	3241106	19.7%
I	3157135	19.2%
O	2242380	13.7%
T	961875	5.9%
A	937063	5.7%
C	857983	5.2%
R	849363	5.2%
U	780701	4.8%
Y	780701	4.8%
J	780701	4.8%
Other values (7)	1837848	11.2%

Space Separator

Value	Count	Frequency (%)
	2256201	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	34331	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16426856	87.8%
Common	2290532	12.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	3241106	19.7%
I	3157135	19.2%
O	2242380	13.7%
T	961875	5.9%
A	937063	5.7%
C	857983	5.2%
R	849363	5.2%
U	780701	4.8%
Y	780701	4.8%
J	780701	4.8%
Other values (7)	1837848	11.2%

Common

Value	Count	Frequency (%)
	2256201	98.5%
,	34331	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18717388	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	3241106	17.3%
I	3157135	16.9%
	2256201	12.1%
O	2242380	12.0%
T	961875	5.1%
A	937063	5.0%
C	857983	4.6%
R	849363	4.5%
U	780701	4.2%
Y	780701	4.2%
Other values (9)	2652880	14.2%

INJURIES_TOTAL
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	20
Distinct (%)	< 0.1%
Missing	1780
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.18992381

Minimum	0
Maximum	21
Zeros	703431
Zeros (%)	86.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.56603807
Coefficient of variation (CV)	2.9803429
Kurtosis	45.551048
Mean	0.18992381
Median Absolute Deviation (MAD)	0
Skewness	4.8263445
Sum	154967
Variance	0.32039909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	703431	86.0%
1	84676	10.4%
2	18829	2.3%
3	5721	0.7%
4	2050	0.3%
5	723	0.1%
6	289	< 0.1%
7	110	< 0.1%
8	45	< 0.1%
9	26	< 0.1%
Other values (10)	43	< 0.1%
(Missing)	1780	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	703431	86.0%
1	84676	10.4%
2	18829	2.3%
3	5721	0.7%
4	2050	0.3%
5	723	0.1%
6	289	< 0.1%
7	110	< 0.1%
8	45	< 0.1%
9	26	< 0.1%

Value	Count	Frequency (%)
21	4	< 0.1%
19	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
15	7	< 0.1%
14	1	< 0.1%
13	2	< 0.1%
12	4	< 0.1%
11	8	< 0.1%
10	14	< 0.1%

INJURIES_FATAL
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	1780
Missing (%)	0.2%
Memory size	6.2 MiB

0.0	815044
1.0	836
2.0	54
3.0	8
4.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2447829
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	815044	99.7%
1.0	836	0.1%
2.0	54	< 0.1%
3.0	8	< 0.1%
4.0	1	< 0.1%
(Missing)	1780	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	815044	99.9%
1.0	836	0.1%
2.0	54	< 0.1%
3.0	8	< 0.1%
4.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	1630987	66.6%
.	815943	33.3%
1	836	< 0.1%
2	54	< 0.1%
3	8	< 0.1%
4	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1631886	66.7%
Other Punctuation	815943	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1630987	99.9%
1	836	0.1%
2	54	< 0.1%
3	8	< 0.1%
4	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	815943	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2447829	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1630987	66.6%
.	815943	33.3%
1	836	< 0.1%
2	54	< 0.1%
3	8	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2447829	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1630987	66.6%
.	815943	33.3%
1	836	< 0.1%
2	54	< 0.1%
3	8	< 0.1%
4	1	< 0.1%

INJURIES_INCAPACITATING
Real number (ℝ)

ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	1780
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.019908253

Minimum	0
Maximum	10
Zeros	801987
Zeros (%)	98.1%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.16511357
Coefficient of variation (CV)	8.2937243
Kurtosis	193.15979
Mean	0.019908253
Median Absolute Deviation (MAD)	0
Skewness	11.32382
Sum	16244
Variance	0.02726249
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	801987	98.1%
1	12271	1.5%
2	1269	0.2%
3	282	< 0.1%
4	98	< 0.1%
5	26	< 0.1%
6	7	< 0.1%
7	1	< 0.1%
10	1	< 0.1%
8	1	< 0.1%
(Missing)	1780	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	801987	98.1%
1	12271	1.5%
2	1269	0.2%
3	282	< 0.1%
4	98	< 0.1%
5	26	< 0.1%
6	7	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
8	1	< 0.1%
7	1	< 0.1%
6	7	< 0.1%
5	26	< 0.1%
4	98	< 0.1%
3	282	< 0.1%
2	1269	0.2%
1	12271	1.5%
0	801987	98.1%

INJURIES_NON_INCAPACITATING
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	19
Distinct (%)	< 0.1%
Missing	1780
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.10711778

Minimum	0
Maximum	21
Zeros	749965
Zeros (%)	91.7%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.42226344
Coefficient of variation (CV)	3.9420482
Kurtosis	79.874379
Mean	0.10711778
Median Absolute Deviation (MAD)	0
Skewness	6.3551825
Sum	87402
Variance	0.17830641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	749965	91.7%
1	51685	6.3%
2	9835	1.2%
3	2873	0.4%
4	999	0.1%
5	348	< 0.1%
6	141	< 0.1%
7	46	< 0.1%
8	22	< 0.1%
10	9	< 0.1%
Other values (9)	20	< 0.1%
(Missing)	1780	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	749965	91.7%
1	51685	6.3%
2	9835	1.2%
3	2873	0.4%
4	999	0.1%
5	348	< 0.1%
6	141	< 0.1%
7	46	< 0.1%
8	22	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
21	2	< 0.1%
19	1	< 0.1%
18	1	< 0.1%
16	1	< 0.1%
15	1	< 0.1%
14	1	< 0.1%
12	3	< 0.1%
11	4	< 0.1%
10	9	< 0.1%
9	6	< 0.1%

INJURIES_REPORTED_NOT_EVIDENT
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	13
Distinct (%)	< 0.1%
Missing	1780
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.061706516

Minimum	0
Maximum	15
Zeros	777695
Zeros (%)	95.1%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.31924399
Coefficient of variation (CV)	5.1735864
Kurtosis	96.640062
Mean	0.061706516
Median Absolute Deviation (MAD)	0
Skewness	7.6941999
Sum	50349
Variance	0.10191673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	777695	95.1%
1	29752	3.6%
2	6145	0.8%
3	1586	0.2%
4	496	0.1%
5	172	< 0.1%
6	45	< 0.1%
7	22	< 0.1%
8	11	< 0.1%
9	9	< 0.1%
Other values (3)	10	< 0.1%
(Missing)	1780	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	777695	95.1%
1	29752	3.6%
2	6145	0.8%
3	1586	0.2%
4	496	0.1%
5	172	< 0.1%
6	45	< 0.1%
7	22	< 0.1%
8	11	< 0.1%
9	9	< 0.1%

Value	Count	Frequency (%)
15	2	< 0.1%
11	2	< 0.1%
10	6	< 0.1%
9	9	< 0.1%
8	11	< 0.1%
7	22	< 0.1%
6	45	< 0.1%
5	172	< 0.1%
4	496	0.1%
3	1586	0.2%

INJURIES_NO_INDICATION
Real number (ℝ)

ZEROS

Distinct	48
Distinct (%)	< 0.1%
Missing	1780
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	2.0032404

Minimum	0
Maximum	61
Zeros	17119
Zeros (%)	2.1%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	4
Maximum	61
Range	61
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1571173
Coefficient of variation (CV)	0.57762278
Kurtosis	69.611204
Mean	2.0032404
Median Absolute Deviation (MAD)	1
Skewness	3.763925
Sum	1634530
Variance	1.3389205
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
2	379375	46.4%
1	250061	30.6%
3	103077	12.6%
4	38515	4.7%
0	17119	2.1%
5	16170	2.0%
6	6706	0.8%
7	2609	0.3%
8	1168	0.1%
9	484	0.1%
Other values (38)	659	0.1%
(Missing)	1780	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17119	2.1%
1	250061	30.6%
2	379375	46.4%
3	103077	12.6%
4	38515	4.7%
5	16170	2.0%
6	6706	0.8%
7	2609	0.3%
8	1168	0.1%
9	484	0.1%

Value	Count	Frequency (%)
61	1	< 0.1%
50	1	< 0.1%
48	1	< 0.1%
46	1	< 0.1%
45	2	< 0.1%
43	1	< 0.1%
42	3	< 0.1%
40	2	< 0.1%
39	1	< 0.1%
38	1	< 0.1%

INJURIES_UNKNOWN
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	1780
Missing (%)	0.2%
Memory size	6.2 MiB

0.0	815943

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	2447829
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	815943	99.8%
(Missing)	1780	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	815943	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1631886	66.7%
.	815943	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1631886	66.7%
Other Punctuation	815943	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1631886	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	815943	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2447829	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1631886	66.7%
.	815943	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2447829	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1631886	66.7%
.	815943	33.3%

CRASH_HOUR
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.198073

Minimum	0
Maximum	23
Zeros	17728
Zeros (%)	2.2%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	9
median	14
Q3	17
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.5700507
Coefficient of variation (CV)	0.42203514
Kurtosis	-0.38952782
Mean	13.198073
Median Absolute Deviation (MAD)	4
Skewness	-0.42698356
Sum	10792368
Variance	31.025465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
15	63101	7.7%
16	62452	7.6%
17	60858	7.4%
14	54756	6.7%
18	50210	6.1%
13	49604	6.1%
12	47942	5.9%
8	43242	5.3%
11	41461	5.1%
9	37509	4.6%
Other values (14)	306588	37.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17728	2.2%
1	15210	1.9%
2	13085	1.6%
3	10681	1.3%
4	9509	1.2%
5	11295	1.4%
6	17792	2.2%
7	34569	4.2%
8	43242	5.3%
9	37509	4.6%

Value	Count	Frequency (%)
23	21276	2.6%
22	24553	3.0%
21	26734	3.3%
20	29896	3.7%
19	37090	4.5%
18	50210	6.1%
17	60858	7.4%
16	62452	7.6%
15	63101	7.7%
14	54756	6.7%

CRASH_DAY_OF_WEEK
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1228167

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9808553
Coefficient of variation (CV)	0.48046165
Kurtosis	-1.2397911
Mean	4.1228167
Median Absolute Deviation (MAD)	2
Skewness	-0.0772494
Sum	3371322
Variance	3.9237877
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	132905	16.3%
7	121206	14.8%
5	117337	14.3%
3	116478	14.2%
4	115685	14.1%
2	112479	13.8%
1	101633	12.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	101633	12.4%
2	112479	13.8%
3	116478	14.2%
4	115685	14.1%
5	117337	14.3%
6	132905	16.3%
7	121206	14.8%

Value	Count	Frequency (%)
7	121206	14.8%
6	132905	16.3%
5	117337	14.3%
4	115685	14.1%
3	116478	14.2%
2	112479	13.8%
1	101633	12.4%

CRASH_MONTH
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.6558235

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4525324
Coefficient of variation (CV)	0.51872354
Kurtosis	-1.2109649
Mean	6.6558235
Median Absolute Deviation (MAD)	3
Skewness	-0.079796985
Sum	5442620
Variance	11.91998
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
10	76799	9.4%
9	72415	8.9%
8	70898	8.7%
12	70824	8.7%
11	69260	8.5%
7	68963	8.4%
6	67560	8.3%
5	66530	8.1%
1	66052	8.1%
3	65988	8.1%
Other values (2)	122434	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	66052	8.1%
2	65270	8.0%
3	65988	8.1%
4	57164	7.0%
5	66530	8.1%
6	67560	8.3%
7	68963	8.4%
8	70898	8.7%
9	72415	8.9%
10	76799	9.4%

Value	Count	Frequency (%)
12	70824	8.7%
11	69260	8.5%
10	76799	9.4%
9	72415	8.9%
8	70898	8.7%
7	68963	8.4%
6	67560	8.3%
5	66530	8.1%
4	57164	7.0%
3	65988	8.1%

LATITUDE
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	300091
Distinct (%)	37.0%
Missing	5615
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	41.854865

Minimum	0
Maximum	42.02278
Zeros	49
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.2 MiB

Quantile statistics

Minimum	0
5-th percentile	41.712613
Q1	41.782524
median	41.874799
Q3	41.924392
95-th percentile	41.990161
Maximum	42.02278
Range	42.02278
Interquartile range (IQR)	0.1418673

Descriptive statistics

Standard deviation	0.33634838
Coefficient of variation (CV)	0.008036064
Kurtosis	14465.142
Mean	41.854865
Median Absolute Deviation (MAD)	0.068387089
Skewness	-116.26865
Sum	33990671
Variance	0.11313023
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.97620114	1305	0.2%
41.90095892	759	0.1%
41.79142028	578	0.1%
41.7514606	556	0.1%
41.72225727	443	0.1%
41.75466012	381	< 0.1%
41.88085605	329	< 0.1%
41.78932932	325	< 0.1%
41.90075297	306	< 0.1%
41.89680497	304	< 0.1%
Other values (300081)	806822	98.7%
(Missing)	5615	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	49	< 0.1%
41.64467013	23	< 0.1%
41.64469152	4	< 0.1%
41.64469397	7	< 0.1%
41.64469408	1	< 0.1%
41.64470194	5	< 0.1%
41.64471103	1	< 0.1%
41.64471232	1	< 0.1%
41.64471457	1	< 0.1%
41.64471544	4	< 0.1%

Value	Count	Frequency (%)
42.02277986	9	< 0.1%
42.02275469	1	< 0.1%
42.02273632	1	< 0.1%
42.02272017	2	< 0.1%
42.02266893	1	< 0.1%
42.02266114	2	< 0.1%
42.02266027	7	< 0.1%
42.02265996	1	< 0.1%
42.02265785	1	< 0.1%
42.0226457	1	< 0.1%

LONGITUDE
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	300054
Distinct (%)	36.9%
Missing	5615
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	-87.673537

Minimum	-87.936193
Maximum	0
Zeros	49
Zeros (%)	< 0.1%
Negative	812059
Negative (%)	99.3%
Memory size	6.2 MiB

Quantile statistics

Minimum	-87.936193
5-th percentile	-87.776925
Q1	-87.72175
median	-87.674171
Q3	-87.633404
95-th percentile	-87.585783
Maximum	0
Range	87.936193
Interquartile range (IQR)	0.088345474

Descriptive statistics

Standard deviation	0.68359378
Coefficient of variation (CV)	-0.0077970366
Kurtosis	16322.547
Mean	-87.673537
Median Absolute Deviation (MAD)	0.043139996
Skewness	127.28991
Sum	-71200381
Variance	0.46730046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.90530913	1305	0.2%
-87.61992817	759	0.1%
-87.58014777	578	0.1%
-87.58597199	556	0.1%
-87.58527557	443	0.1%
-87.74138476	381	< 0.1%
-87.61763589	329	< 0.1%
-87.74164564	325	< 0.1%
-87.624235	306	< 0.1%
-87.61702742	304	< 0.1%
Other values (300044)	806822	98.7%
(Missing)	5615	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.93619295	1	< 0.1%
-87.93587692	1	< 0.1%
-87.93476313	3	< 0.1%
-87.93450972	1	< 0.1%
-87.93401422	1	< 0.1%
-87.93399393	54	< 0.1%
-87.9339765	3	< 0.1%
-87.93302828	8	< 0.1%
-87.92822117	3	< 0.1%
-87.92726168	13	< 0.1%

Value	Count	Frequency (%)
0	49	< 0.1%
-87.52458739	13	< 0.1%
-87.52458901	4	< 0.1%
-87.52464032	1	< 0.1%
-87.5246459	1	< 0.1%
-87.52467395	8	< 0.1%
-87.52467489	1	< 0.1%
-87.52467584	1	< 0.1%
-87.52467708	1	< 0.1%
-87.52468243	1	< 0.1%

LOCATION
Text

Distinct	300265
Distinct (%)	37.0%
Missing	5615
Missing (%)	0.7%
Memory size	6.2 MiB

Length

Max length	40
Median length	40
Mean length	39.779569
Min length	11

Characters and Unicode

Total characters	32305306
Distinct characters	20
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	190046 ?
Unique (%)	23.4%

Sample

1st row	POINT (-87.665902342962 41.854120262952)
2nd row	POINT (-87.761883496974 41.942975745006)
3rd row	POINT (-87.594212812011 41.809781151018)
4th row	POINT (-87.696642374961 41.899224596015)
5th row	POINT (-87.585945066953 41.744151639042)

Value	Count	Frequency (%)
point	812108	33.3%
41.976201139024	1305	0.1%
87.905309125103	1305	0.1%
87.619928173678	759	< 0.1%
41.900958919109	759	< 0.1%
87.580147768689	578	< 0.1%
41.791420282098	578	< 0.1%
87.585971992965	556	< 0.1%
41.751460603167	556	< 0.1%
87.585275565077	443	< 0.1%
Other values (600520)	1617377	66.4%

Most occurring characters

Value	Count	Frequency (%)
7	3089155	9.6%
8	2891746	9.0%
4	2599622	8.0%
1	2545102	7.9%
6	2307184	7.1%
9	2047841	6.3%
5	1864201	5.8%
2	1822984	5.6%
3	1785259	5.5%
	1624216	5.0%
Other values (10)	9727996	30.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	22560157	69.8%
Uppercase Letter	4060540	12.6%
Space Separator	1624216	5.0%
Other Punctuation	1624118	5.0%
Open Punctuation	812108	2.5%
Close Punctuation	812108	2.5%
Dash Punctuation	812059	2.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
7	3089155	13.7%
8	2891746	12.8%
4	2599622	11.5%
1	2545102	11.3%
6	2307184	10.2%
9	2047841	9.1%
5	1864201	8.3%
2	1822984	8.1%
3	1785259	7.9%
0	1607063	7.1%

Uppercase Letter

Value	Count	Frequency (%)
P	812108	20.0%
O	812108	20.0%
T	812108	20.0%
N	812108	20.0%
I	812108	20.0%

Space Separator

Value	Count	Frequency (%)
	1624216	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	1624118	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	812108	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	812108	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	812059	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	28244766	87.4%
Latin	4060540	12.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
7	3089155	10.9%
8	2891746	10.2%
4	2599622	9.2%
1	2545102	9.0%
6	2307184	8.2%
9	2047841	7.3%
5	1864201	6.6%
2	1822984	6.5%
3	1785259	6.3%
	1624216	5.8%
Other values (5)	5667456	20.1%

Latin

Value	Count	Frequency (%)
P	812108	20.0%
O	812108	20.0%
T	812108	20.0%
N	812108	20.0%
I	812108	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32305306	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	3089155	9.6%
8	2891746	9.0%
4	2599622	8.0%
1	2545102	7.9%
6	2307184	7.1%
9	2047841	6.3%
5	1864201	5.8%
2	1822984	5.6%
3	1785259	5.5%
	1624216	5.0%
Other values (10)	9727996	30.1%

Auto

Heatmap
Table

	ALIGNMENT	BEAT_OF_OCCURRENCE	CRASH_DATE_EST_I	CRASH_DAY_OF_WEEK	CRASH_HOUR	CRASH_MONTH	CRASH_TYPE	DAMAGE	DEVICE_CONDITION	DOORING_I	FIRST_CRASH_TYPE	HIT_AND_RUN_I	INJURIES_FATAL	INJURIES_INCAPACITATING	INJURIES_NON_INCAPACITATING	INJURIES_NO_INDICATION	INJURIES_REPORTED_NOT_EVIDENT	INJURIES_TOTAL	INTERSECTION_RELATED_I	LANE_CNT	LATITUDE	LIGHTING_CONDITION	LONGITUDE	MOST_SEVERE_INJURY	NOT_RIGHT_OF_WAY_I	NUM_UNITS	PHOTOS_TAKEN_I	POSTED_SPEED_LIMIT	PRIM_CONTRIBUTORY_CAUSE	REPORT_TYPE	ROADWAY_SURFACE_COND	ROAD_DEFECT	SEC_CONTRIBUTORY_CAUSE	STATEMENTS_TAKEN_I	STREET_DIRECTION	STREET_NO	TRAFFICWAY_TYPE	TRAFFIC_CONTROL_DEVICE	WEATHER_CONDITION	WORKERS_PRESENT_I	WORK_ZONE_I	WORK_ZONE_TYPE
ALIGNMENT	1.000	0.000	0.015	0.001	0.008	-0.004	0.055	0.016	0.013	0.017	0.059	0.007	0.006	0.000	0.001	0.008	0.006	0.004	0.015	-0.011	-0.036	0.016	-0.018	0.012	0.004	0.030	0.000	-0.020	0.042	0.046	0.026	0.023	0.027	0.000	0.027	0.006	0.092	0.032	0.022	0.000	0.058	0.000
BEAT_OF_OCCURRENCE	0.000	1.000	0.029	0.004	0.004	0.001	0.048	0.043	0.030	0.269	0.043	0.020	0.005	-0.013	-0.026	-0.005	-0.015	-0.031	0.011	-0.054	0.660	0.023	-0.504	0.018	0.039	0.023	0.064	-0.057	0.052	0.032	0.032	0.027	0.041	0.055	0.433	0.008	0.069	0.039	0.022	0.000	0.027	0.030
CRASH_DATE_EST_I	0.015	0.029	1.000	0.002	-0.024	-0.005	0.092	0.034	0.052	0.101	0.081	0.035	0.006	-0.025	-0.064	-0.045	-0.040	-0.080	0.026	-0.065	0.030	0.110	-0.026	0.080	0.078	-0.021	0.126	-0.024	0.085	0.116	0.081	0.018	0.056	0.145	0.014	0.018	0.072	0.054	0.095	0.136	0.202	0.048
CRASH_DAY_OF_WEEK	0.001	0.004	0.002	1.000	0.056	-0.001	0.047	0.026	0.007	0.000	0.031	0.000	0.003	-0.002	-0.005	0.026	-0.000	-0.005	0.000	0.010	0.003	0.062	0.005	0.009	0.005	0.004	0.019	0.009	0.026	0.023	0.013	0.005	0.014	0.000	0.005	-0.010	0.013	0.009	0.017	0.333	0.103	0.036
CRASH_HOUR	0.008	0.004	-0.024	0.056	1.000	0.005	0.157	0.068	0.021	0.184	0.071	0.013	0.014	0.001	0.007	0.087	0.005	0.010	0.015	0.014	0.003	0.380	0.013	0.031	0.080	0.021	0.049	0.024	0.063	0.103	0.035	0.027	0.035	0.039	0.018	-0.002	0.038	0.020	0.038	0.323	0.119	0.054
CRASH_MONTH	-0.004	0.001	-0.005	-0.001	0.005	1.000	0.015	0.009	0.006	0.115	0.024	0.000	0.002	0.005	0.012	0.002	0.004	0.014	0.004	0.009	0.003	0.077	-0.001	0.016	0.000	0.011	0.040	0.010	0.036	0.006	0.144	0.016	0.024	0.023	0.006	-0.001	0.008	0.007	0.101	0.065	0.054	0.028
CRASH_TYPE	0.055	0.048	0.092	0.047	0.157	0.015	1.000	0.248	0.113	0.204	0.360	0.065	0.055	-0.219	-0.492	0.184	-0.368	-0.662	0.039	-0.066	0.053	0.163	-0.007	0.663	0.094	-0.074	0.056	-0.109	0.298	0.497	0.111	0.062	0.163	0.027	0.026	-0.021	0.214	0.129	0.101	0.042	0.051	0.025
DAMAGE	0.016	0.043	0.034	0.026	0.068	0.009	0.248	1.000	0.029	0.158	0.220	0.022	0.012	0.028	0.054	-0.008	0.044	0.070	0.026	0.037	-0.048	0.057	-0.017	0.092	0.042	0.062	0.080	0.058	0.104	0.135	0.028	0.025	0.058	0.025	0.025	0.030	0.079	0.039	0.021	0.000	0.036	0.000
DEVICE_CONDITION	0.013	0.030	0.052	0.007	0.021	0.006	0.113	0.029	1.000	0.246	0.161	0.020	0.000	-0.030	-0.084	-0.194	-0.072	-0.113	0.161	-0.207	0.031	0.129	-0.038	0.064	0.111	-0.048	0.030	-0.131	0.122	0.064	0.139	0.160	0.063	0.024	0.019	0.048	0.168	0.467	0.117	0.058	0.065	0.057
DOORING_I	0.017	0.269	0.101	0.000	0.184	0.115	0.204	0.158	0.246	1.000	0.548	0.000	0.026	0.024	0.206	-0.138	0.009	0.225	0.000	-0.015	0.286	0.125	0.017	0.257	0.000	-0.002	0.000	0.036	0.279	0.008	0.082	0.000	0.206	0.000	0.263	-0.116	0.250	0.272	0.073	NaN	0.000	0.000
FIRST_CRASH_TYPE	0.059	0.043	0.081	0.031	0.071	0.024	0.360	0.220	0.161	0.548	1.000	0.121	0.033	-0.034	-0.050	0.387	0.002	-0.049	0.171	0.276	0.029	0.096	0.020	0.230	0.102	0.168	0.038	0.157	0.279	0.179	0.062	0.136	0.136	0.057	0.040	-0.058	0.137	0.136	0.048	0.091	0.212	0.087
HIT_AND_RUN_I	0.007	0.020	0.035	0.000	0.013	0.000	0.065	0.022	0.020	0.000	0.121	1.000	0.003	-0.019	-0.036	-0.030	-0.014	-0.039	0.021	-0.016	0.019	0.028	-0.015	0.040	0.064	0.033	0.030	-0.018	0.105	0.035	0.024	0.007	0.053	0.043	0.017	-0.005	0.033	0.020	0.024	0.000	0.163	0.000
INJURIES_FATAL	0.006	0.005	0.006	0.003	0.014	0.002	0.055	0.012	0.000	0.026	0.033	0.003	1.000	0.034	0.015	-0.037	0.001	0.085	0.005	0.005	-0.011	0.012	0.003	0.500	0.016	-0.004	0.048	0.008	0.025	0.022	0.003	0.002	0.013	0.000	0.005	0.006	0.009	0.003	0.001	0.000	0.033	0.000
INJURIES_INCAPACITATING	0.000	-0.013	-0.025	-0.002	0.001	0.005	-0.219	0.028	-0.030	0.024	-0.034	-0.019	0.034	1.000	0.044	-0.111	0.005	0.332	0.000	0.020	-0.010	0.008	0.003	0.170	0.010	0.021	0.010	0.031	0.019	0.030	0.005	0.002	0.016	0.002	0.004	0.004	0.010	0.006	0.002	0.020	0.000	0.000
INJURIES_NON_INCAPACITATING	0.001	-0.026	-0.064	-0.005	0.007	0.012	-0.492	0.054	-0.084	0.206	-0.050	-0.036	0.015	0.044	1.000	-0.214	0.005	0.745	0.008	0.047	-0.028	0.012	0.014	0.119	0.011	0.057	0.017	0.062	0.025	0.049	0.007	0.003	0.015	0.015	0.011	0.003	0.017	0.013	0.005	0.000	0.000	0.000
INJURIES_NO_INDICATION	0.008	-0.005	-0.045	0.026	0.087	0.002	0.184	-0.008	-0.194	-0.138	0.387	-0.030	-0.037	-0.111	-0.214	1.000	-0.122	-0.270	0.000	0.220	0.015	0.006	0.002	0.002	0.018	0.214	0.000	0.139	0.014	0.024	0.004	0.004	0.011	0.000	0.005	-0.049	0.007	0.009	0.004	0.000	0.000	0.006
INJURIES_REPORTED_NOT_EVIDENT	0.006	-0.015	-0.040	-0.000	0.005	0.004	-0.368	0.044	-0.072	0.009	0.002	-0.014	0.001	0.005	0.005	-0.122	1.000	0.559	0.010	0.047	-0.025	0.009	0.006	0.218	0.018	0.059	0.000	0.047	0.021	0.044	0.008	0.006	0.016	0.000	0.009	0.003	0.018	0.017	0.008	0.000	0.019	0.000
INJURIES_TOTAL	0.004	-0.031	-0.080	-0.005	0.010	0.014	-0.662	0.070	-0.113	0.225	-0.049	-0.039	0.085	0.332	0.745	-0.270	0.559	1.000	0.014	0.068	-0.038	0.016	0.015	0.139	0.022	0.077	0.000	0.083	0.033	0.065	0.010	0.006	0.021	0.014	0.014	0.005	0.023	0.018	0.007	0.000	0.000	0.010
INTERSECTION_RELATED_I	0.015	0.011	0.026	0.000	0.015	0.004	0.039	0.026	0.161	0.000	0.171	0.021	0.005	0.000	0.008	0.000	0.010	0.014	1.000	0.010	-0.000	0.018	0.001	0.032	0.022	0.008	0.132	0.012	0.097	0.007	0.010	0.014	0.049	0.117	0.010	0.001	0.133	0.191	0.012	0.000	0.154	0.066
LANE_CNT	-0.011	-0.054	-0.065	0.010	0.014	0.009	-0.066	0.037	-0.207	-0.015	0.276	-0.016	0.005	0.020	0.047	0.220	0.047	0.068	0.010	1.000	-0.009	0.004	0.076	0.000	1.000	0.032	1.000	0.320	0.000	0.000	0.000	0.000	0.000	1.000	0.000	-0.055	0.000	0.013	0.000	1.000	1.000	1.000
LATITUDE	-0.036	0.660	0.030	0.003	0.003	0.003	0.053	-0.048	0.031	0.286	0.029	0.019	-0.011	-0.010	-0.028	0.015	-0.025	-0.038	-0.000	-0.009	1.000	0.003	-0.463	0.002	1.000	0.020	1.000	-0.030	0.000	0.000	0.000	0.000	0.007	1.000	0.009	-0.169	0.005	0.007	0.000	1.000	1.000	1.000
LIGHTING_CONDITION	0.016	0.023	0.110	0.062	0.380	0.077	0.163	0.057	0.129	0.125	0.096	0.028	0.012	0.008	0.012	0.006	0.009	0.016	0.018	0.004	0.003	1.000	-0.014	0.044	0.077	0.003	0.019	-0.047	0.101	0.114	0.244	0.131	0.057	0.032	0.019	0.009	0.105	0.134	0.303	0.273	0.107	0.042
LONGITUDE	-0.018	-0.504	-0.026	0.005	0.013	-0.001	-0.007	-0.017	-0.038	0.017	0.020	-0.015	0.003	0.003	0.014	0.002	0.006	0.015	0.001	0.076	-0.463	-0.014	1.000	0.002	1.000	-0.045	1.000	0.056	0.000	0.000	0.000	0.000	0.007	1.000	0.009	-0.190	0.005	0.007	0.000	1.000	1.000	1.000
MOST_SEVERE_INJURY	0.012	0.018	0.080	0.009	0.031	0.016	0.663	0.092	0.064	0.257	0.230	0.040	0.500	0.170	0.119	0.002	0.218	0.139	0.032	0.000	0.002	0.044	0.002	1.000	0.065	0.058	0.055	0.057	0.115	0.208	0.036	0.018	0.062	0.019	0.012	0.000	0.084	0.069	0.035	0.000	0.062	0.014
NOT_RIGHT_OF_WAY_I	0.004	0.039	0.078	0.005	0.080	0.000	0.094	0.042	0.111	0.000	0.102	0.064	0.016	0.010	0.011	0.018	0.018	0.022	0.022	1.000	1.000	0.077	1.000	0.065	1.000	-0.020	0.204	-0.144	0.095	0.079	0.028	0.013	0.056	0.184	0.016	-0.004	0.235	0.149	0.031	0.000	0.176	0.000
NUM_UNITS	0.030	0.023	-0.021	0.004	0.021	0.011	-0.074	0.062	-0.048	-0.002	0.168	0.033	-0.004	0.021	0.057	0.214	0.059	0.077	0.008	0.032	0.020	0.003	-0.045	0.058	-0.020	1.000	0.048	0.040	0.055	0.128	0.018	0.014	0.031	0.028	0.006	0.012	0.024	0.009	0.014	0.000	0.058	0.000
PHOTOS_TAKEN_I	0.000	0.064	0.126	0.019	0.049	0.040	0.056	0.080	0.030	0.000	0.038	0.030	0.048	0.010	0.017	0.000	0.000	0.000	0.132	1.000	1.000	0.019	1.000	0.055	0.204	0.048	1.000	-0.003	0.075	0.157	0.008	0.028	0.040	0.607	0.016	0.015	0.057	0.044	0.019	0.222	0.277	0.000
POSTED_SPEED_LIMIT	-0.020	-0.057	-0.024	0.009	0.024	0.010	-0.109	0.058	-0.131	0.036	0.157	-0.018	0.008	0.031	0.062	0.139	0.047	0.083	0.012	0.320	-0.030	-0.047	0.056	0.057	-0.144	0.040	-0.003	1.000	0.084	0.042	0.024	0.018	0.042	0.022	0.060	-0.017	0.256	0.089	0.021	0.084	0.095	0.044
PRIM_CONTRIBUTORY_CAUSE	0.042	0.052	0.085	0.026	0.063	0.036	0.298	0.104	0.122	0.279	0.279	0.105	0.025	0.019	0.025	0.014	0.021	0.033	0.097	0.000	0.000	0.101	0.000	0.115	0.095	0.055	0.075	0.084	1.000	0.177	0.162	0.186	0.194	0.072	0.047	0.007	0.093	0.116	0.107	0.145	0.191	0.042
REPORT_TYPE	0.046	0.032	0.116	0.023	0.103	0.006	0.497	0.135	0.064	0.008	0.179	0.035	0.022	0.030	0.049	0.024	0.044	0.065	0.007	0.000	0.000	0.114	0.000	0.208	0.079	0.128	0.157	0.042	0.177	1.000	0.125	0.092	0.106	0.016	0.014	0.019	0.129	0.076	0.110	0.060	0.021	0.149
ROADWAY_SURFACE_COND	0.026	0.032	0.081	0.013	0.035	0.144	0.111	0.028	0.139	0.082	0.062	0.024	0.003	0.005	0.007	0.004	0.008	0.010	0.010	0.000	0.000	0.244	0.000	0.036	0.028	0.018	0.008	0.024	0.162	0.125	1.000	0.224	0.110	0.024	0.022	0.004	0.084	0.123	0.515	0.039	0.079	0.050
ROAD_DEFECT	0.023	0.027	0.018	0.005	0.027	0.016	0.062	0.025	0.160	0.000	0.136	0.007	0.002	0.002	0.003	0.004	0.006	0.006	0.014	0.000	0.000	0.131	0.000	0.018	0.013	0.014	0.028	0.018	0.186	0.092	0.224	1.000	0.103	0.000	0.013	0.003	0.071	0.124	0.149	0.000	0.246	0.071
SEC_CONTRIBUTORY_CAUSE	0.027	0.041	0.056	0.014	0.035	0.024	0.163	0.058	0.063	0.206	0.136	0.053	0.013	0.016	0.015	0.011	0.016	0.021	0.049	0.000	0.007	0.057	0.007	0.062	0.056	0.031	0.040	0.042	0.194	0.106	0.110	0.103	1.000	0.018	0.025	0.009	0.046	0.059	0.080	0.140	0.116	0.025
STATEMENTS_TAKEN_I	0.000	0.055	0.145	0.000	0.039	0.023	0.027	0.025	0.024	0.000	0.057	0.043	0.000	0.002	0.015	0.000	0.000	0.014	0.117	1.000	1.000	0.032	1.000	0.019	0.184	0.028	0.607	0.022	0.072	0.016	0.024	0.000	0.018	1.000	0.025	0.010	0.045	0.035	0.031	0.000	0.194	0.107
STREET_DIRECTION	0.027	0.433	0.014	0.005	0.018	0.006	0.026	0.025	0.019	0.263	0.040	0.017	0.005	0.004	0.011	0.005	0.009	0.014	0.010	0.000	0.009	0.019	0.009	0.012	0.016	0.006	0.016	0.060	0.047	0.014	0.022	0.013	0.025	0.025	1.000	0.074	0.061	0.028	0.017	0.000	0.000	0.000
STREET_NO	0.006	0.008	0.018	-0.010	-0.002	-0.001	-0.021	0.030	0.048	-0.116	-0.058	-0.005	0.006	0.004	0.003	-0.049	0.003	0.005	0.001	-0.055	-0.169	0.009	-0.190	0.000	-0.004	0.012	0.015	-0.017	0.007	0.019	0.004	0.003	0.009	0.010	0.074	1.000	0.000	0.000	0.000	1.000	1.000	1.000
TRAFFICWAY_TYPE	0.092	0.069	0.072	0.013	0.038	0.008	0.214	0.079	0.168	0.250	0.137	0.033	0.009	0.010	0.017	0.007	0.018	0.023	0.133	0.000	0.005	0.105	0.005	0.084	0.235	0.024	0.057	0.256	0.093	0.129	0.084	0.071	0.046	0.045	0.061	0.000	1.000	0.121	0.064	0.084	0.219	0.059
TRAFFIC_CONTROL_DEVICE	0.032	0.039	0.054	0.009	0.020	0.007	0.129	0.039	0.467	0.272	0.136	0.020	0.003	0.006	0.013	0.009	0.017	0.018	0.191	0.013	0.007	0.134	0.007	0.069	0.149	0.009	0.044	0.089	0.116	0.076	0.123	0.124	0.059	0.035	0.028	0.000	0.121	1.000	0.093	0.083	0.133	0.061
WEATHER_CONDITION	0.022	0.022	0.095	0.017	0.038	0.101	0.101	0.021	0.117	0.073	0.048	0.024	0.001	0.002	0.005	0.004	0.008	0.007	0.012	0.000	0.000	0.303	0.000	0.035	0.031	0.014	0.019	0.021	0.107	0.110	0.515	0.149	0.080	0.031	0.017	0.000	0.064	0.093	1.000	0.000	0.040	0.060
WORKERS_PRESENT_I	0.000	0.000	0.136	0.333	0.323	0.065	0.042	0.000	0.058	NaN	0.091	0.000	0.000	0.020	0.000	0.000	0.000	0.000	0.000	1.000	1.000	0.273	1.000	0.000	0.000	0.000	0.222	0.084	0.145	0.060	0.039	0.000	0.140	0.000	0.000	1.000	0.084	0.083	0.000	1.000	1.000	0.078
WORK_ZONE_I	0.058	0.027	0.202	0.103	0.119	0.054	0.051	0.036	0.065	0.000	0.212	0.163	0.033	0.000	0.000	0.000	0.019	0.000	0.154	1.000	1.000	0.107	1.000	0.062	0.176	0.058	0.277	0.095	0.191	0.021	0.079	0.246	0.116	0.194	0.000	1.000	0.219	0.133	0.040	1.000	1.000	1.000
WORK_ZONE_TYPE	0.000	0.030	0.048	0.036	0.054	0.028	0.025	0.000	0.057	0.000	0.087	0.000	0.000	0.000	0.000	0.006	0.000	0.010	0.066	1.000	1.000	0.042	1.000	0.014	0.000	0.000	0.000	0.044	0.042	0.149	0.050	0.071	0.025	0.107	0.000	1.000	0.059	0.061	0.060	0.078	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	CRASH_RECORD_ID	CRASH_DATE_EST_I	CRASH_DATE	POSTED_SPEED_LIMIT	TRAFFIC_CONTROL_DEVICE	DEVICE_CONDITION	WEATHER_CONDITION	LIGHTING_CONDITION	FIRST_CRASH_TYPE	TRAFFICWAY_TYPE	LANE_CNT	ALIGNMENT	ROADWAY_SURFACE_COND	ROAD_DEFECT	REPORT_TYPE	CRASH_TYPE	INTERSECTION_RELATED_I	NOT_RIGHT_OF_WAY_I	HIT_AND_RUN_I	DAMAGE	DATE_POLICE_NOTIFIED	PRIM_CONTRIBUTORY_CAUSE	SEC_CONTRIBUTORY_CAUSE	STREET_NO	STREET_DIRECTION	STREET_NAME	BEAT_OF_OCCURRENCE	PHOTOS_TAKEN_I	STATEMENTS_TAKEN_I	DOORING_I	WORK_ZONE_I	WORK_ZONE_TYPE	WORKERS_PRESENT_I	NUM_UNITS	MOST_SEVERE_INJURY	INJURIES_TOTAL	INJURIES_FATAL	INJURIES_NON_INCAPACITATING	INJURIES_NO_INDICATION	CRASH_HOUR	CRASH_DAY_OF_WEEK	CRASH_MONTH	LATITUDE	LONGITUDE	LOCATION
0	6c1659069e9c6285a650e70d6f9b574ed5f64c12888479093dfeef179c0344ec6d2057eae224b5c0d5dfc278c0a237f8c22543f07fdef2e4a95a3849871c9345	NaN	08/18/2023 12:50:00 PM	15	OTHER	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	REAR END	OTHER	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	NaN	OVER $1,500	08/18/2023 12:55:00 PM	FOLLOWING TOO CLOSELY	DISTRACTION - FROM INSIDE VEHICLE	700	W	OHARE ST	1654.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NONINCAPACITATING INJURY	1.0	0.0	1.0	1.0	12	6	8	NaN	NaN	NaN
1	5f54a59fcb087b12ae5b1acff96a3caf4f2d37e79f8db4106558b34b8a6d2b81af02cf91b576ecd7ced08ffd10fcfd940a84f7613125b89d33636e6075064e22	NaN	07/29/2023 02:45:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	PARKED MOTOR VEHICLE	DIVIDED - W/MEDIAN (NOT RAISED)	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	NaN	NaN	Y	OVER $1,500	07/29/2023 02:45:00 PM	FAILING TO REDUCE SPEED TO AVOID CRASH	OPERATING VEHICLE IN ERRATIC, RECKLESS, CARELESS, NEGLIGENT OR AGGRESSIVE MANNER	2101	S	ASHLAND AVE	1235.0	NaN	NaN	NaN	NaN	NaN	NaN	4	NO INDICATION OF INJURY	0.0	0.0	0.0	1.0	14	7	7	41.854120	-87.665902	POINT (-87.665902342962 41.854120262952)
2	61fcb8c1eb522a6469b460e2134df3d15f82e81fd93e9cafd3dc7e631b9e1ba8b450a63af12bd90d1d2d9b127ea287f88d32e138a4eeba17799f536c08048934	NaN	08/18/2023 05:58:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	PEDALCYCLIST	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	NaN	$501 - $1,500	08/18/2023 06:01:00 PM	FAILING TO REDUCE SPEED TO AVOID CRASH	UNABLE TO DETERMINE	3422	N	LONG AVE	1633.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NONINCAPACITATING INJURY	1.0	0.0	1.0	1.0	17	6	8	41.942976	-87.761883	POINT (-87.761883496974 41.942975745006)
3	004cd14d0303a9163aad69a2d7f341b7da2a8572b2ab3378594bfae8ac53dcb604dd8d414f93c290b55862f9f2517ad32e6209cbc8034c2e26eb3c2bc9724390	NaN	11/26/2019 08:38:00 AM	25	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	PEDESTRIAN	ONE-WAY	NaN	CURVE ON GRADE	DRY	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	NaN	OVER $1,500	11/26/2019 08:38:00 AM	UNABLE TO DETERMINE	NOT APPLICABLE	5	W	TERMINAL ST	1655.0	Y	Y	NaN	NaN	NaN	NaN	2	FATAL	1.0	1.0	0.0	1.0	8	3	11	NaN	NaN	NaN
4	a1d5f0ea90897745365a4cbb06cc60329a120d89753fac2b02d69c9685d9cf7c763870a60abd01484a39ed1e6c09b1ba59f38214c03a83cccde1247f794e0287	NaN	08/18/2023 10:45:00 AM	20	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	FIXED OBJECT	OTHER	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	NaN	NaN	NaN	OVER $1,500	08/18/2023 10:48:00 AM	FOLLOWING TOO CLOSELY	DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	3	W	TERMINAL ST	1653.0	NaN	NaN	NaN	NaN	NaN	NaN	1	NO INDICATION OF INJURY	0.0	0.0	0.0	1.0	10	6	8	NaN	NaN	NaN
5	b236c77d59e32b7b469a6e2f17f438b7457e1bd8bc689b14cb4f5b1590cbe784f2b9e554b41925797251cbd3e93a3f4a131d1923b327673d441ae79c052f79c2	NaN	07/29/2023 01:00:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	TURNING	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	UNKNOWN	UNKNOWN	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	Y	NaN	NaN	$501 - $1,500	07/29/2023 01:46:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	1732	N	LA SALLE DR	1814.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	0.0	3.0	13	7	7	NaN	NaN	NaN
6	35156ce97cab22747495e92e8bbb16c57e0e60dc3ce6d1f1852f2f7cece07c7ae825b073b286b1da52dfa58082ff6d763ecf1f13f06a223c7aed2b6c1e8c5972	NaN	02/06/2023 05:30:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DARKNESS, LIGHTED ROAD	REAR END	ONE-WAY	NaN	CURVE, LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	NaN	NaN	NaN	$501 - $1,500	02/06/2023 05:35:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	2	W	TERMINAL ST	1652.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	0.0	2.0	17	2	2	NaN	NaN	NaN
7	0e208d23344f0d1b3a9fcd4bb07676a750ddb73c397b5c398a33743fd0d49b8ce737c7740b1a77cdaebd61e8e79bddb284452d744b16668f9777f256eec28ff5	NaN	08/13/2023 01:30:00 PM	35	NO CONTROLS	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	ANGLE	OTHER	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	NaN	NaN	OVER $1,500	08/13/2023 07:40:00 PM	IMPROPER BACKING	UNABLE TO DETERMINE	9000	S	PROSPECT AVE	2221.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	0.0	2.0	13	1	8	NaN	NaN	NaN
8	14386daec6219c6032b71612b28f0e4cd38e2898f39aae84deeb4efaf165253548cb27cb90088b2d4f9d3e484aa1e7f5076969da4d3b8137a43a3dc94536ac19	NaN	08/13/2023 12:11:00 AM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DARKNESS, LIGHTED ROAD	TURNING	FOUR WAY	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	Y	NaN	NaN	OVER $1,500	08/13/2023 12:11:00 AM	IMPROPER TURNING/NO SIGNAL	UNABLE TO DETERMINE	5900	S	WENTWORTH AVE	232.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	0.0	2.0	0	1	8	NaN	NaN	NaN
9	359bf9f5872d646bb63576e55b1e0b480dc93c2b935ab571dc26ddb48b7a328fbfe130ae70bbff9f03787041b6fb029ba02529da9a1f57494e385ec0e13ed834	NaN	01/31/2022 07:45:00 PM	25	NO CONTROLS	NO CONTROLS	CLEAR	DARKNESS	REAR END	ONE-WAY	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	NaN	Y	$501 - $1,500	01/31/2022 07:58:00 PM	NOT APPLICABLE	NOT APPLICABLE	4546	W	GLADYS AVE	1131.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	0.0	5.0	19	2	1	NaN	NaN	NaN

	CRASH_RECORD_ID	CRASH_DATE_EST_I	CRASH_DATE	POSTED_SPEED_LIMIT	TRAFFIC_CONTROL_DEVICE	DEVICE_CONDITION	WEATHER_CONDITION	LIGHTING_CONDITION	FIRST_CRASH_TYPE	TRAFFICWAY_TYPE	LANE_CNT	ALIGNMENT	ROADWAY_SURFACE_COND	ROAD_DEFECT	REPORT_TYPE	CRASH_TYPE	INTERSECTION_RELATED_I	NOT_RIGHT_OF_WAY_I	HIT_AND_RUN_I	DAMAGE	DATE_POLICE_NOTIFIED	PRIM_CONTRIBUTORY_CAUSE	SEC_CONTRIBUTORY_CAUSE	STREET_NO	STREET_DIRECTION	STREET_NAME	BEAT_OF_OCCURRENCE	PHOTOS_TAKEN_I	STATEMENTS_TAKEN_I	DOORING_I	WORK_ZONE_I	WORK_ZONE_TYPE	WORKERS_PRESENT_I	NUM_UNITS	MOST_SEVERE_INJURY	INJURIES_TOTAL	INJURIES_INCAPACITATING	INJURIES_NO_INDICATION	CRASH_HOUR	CRASH_DAY_OF_WEEK	CRASH_MONTH	LATITUDE	LONGITUDE	LOCATION
817713	5ee5d998db696abf1c85925f71d82015adb33f3b2cdad1942d7d5cf7f077d3ae22547160f024f0ebd1d4a6875fc58fd1e824aa2d1e0a9c53db3cb3d86efb3038	NaN	06/30/2023 09:37:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DARKNESS, LIGHTED ROAD	PARKED MOTOR VEHICLE	DIVIDED - W/MEDIAN (NOT RAISED)	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	NaN	OVER $1,500	06/30/2023 09:38:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	7559	S	UNION AVE	621.0	NaN	NaN	NaN	NaN	NaN	NaN	2	INCAPACITATING INJURY	1.0	1.0	0.0	21	6	6	41.756217	-87.641596	POINT (-87.641596011467 41.756217389831)
817714	3a5f25711e9162f0042a53337a25f2c3dc72893c1172d9320ac6736361e1e92ac801e9efe5515c324128870fc638b9a709c76a9773940e934a87ac3230fba3d8	NaN	11/22/2019 07:30:00 AM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	REAR TO FRONT	DIVIDED - W/MEDIAN (NOT RAISED)	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	NO INJURY / DRIVE AWAY	NaN	NaN	Y	OVER $1,500	11/22/2019 09:15:00 AM	IMPROPER BACKING	UNABLE TO DETERMINE	3959	N	MONTICELLO AVE	1732.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	4.0	7	6	11	41.953655	-87.718926	POINT (-87.718925716094 41.953654536112)
817715	790a72494289861e0d12786c57659df0fcc3ff90df83a6cb1de9271f989813436a7f8ae113e075d3b5e5bd517e4495c072d513638702c6f4cc134f156226c932	Y	09/08/2020 03:10:00 PM	30	NO CONTROLS	NO CONTROLS	RAIN	DUSK	PARKED MOTOR VEHICLE	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	WET	NO DEFECTS	NaN	NO INJURY / DRIVE AWAY	NaN	NaN	Y	$501 - $1,500	09/08/2020 06:19:00 PM	UNABLE TO DETERMINE	NOT APPLICABLE	130	E	34TH ST	211.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	1.0	15	3	9	41.833010	-87.621878	POINT (-87.621877672023 41.833010486005)
817716	5c36f4e91b3deefd051dee799c3957b198389d8fe01247dc7607ce56bd783470260b8a7eaba4d7d9c5e58f44e59ca37b5717088a0e3ebd46a964608fd06a6e14	NaN	01/06/2020 01:03:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	ANGLE	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	NaN	OVER $1,500	01/06/2020 01:03:00 PM	NOT APPLICABLE	NOT APPLICABLE	5635	W	CORCORAN PL	1512.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	2.0	13	2	1	41.887091	-87.766594	POINT (-87.766594246183 41.887090677713)
817717	fcf3c5ddd8ba79a1b43c039a2507b201c999d659aa85d31dc6c939e84a2a6e4fa066b59b74be162a5758acd4cf8f766b6b242e300b4772466949680c62ae7740	NaN	04/12/2020 07:10:00 AM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	DIVIDED - W/MEDIAN (NOT RAISED)	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	NO INJURY / DRIVE AWAY	NaN	NaN	Y	$501 - $1,500	04/12/2020 08:45:00 AM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	2500	S	LAKE SHORE DR SB	133.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	2.0	7	1	4	41.847421	-87.612391	POINT (-87.61239120397 41.847420982326)
817718	6dee8823d4ae96624b741428681d19f50b5960418b6d790275e76ec34ee74f1b85ea13fab7248a863dc3761b4c1a7d96a18e6c8b1bd5777d665971ec3ab5598c	NaN	09/02/2023 06:25:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	REAR END	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	NO INJURY / DRIVE AWAY	NaN	NaN	Y	OVER $1,500	09/02/2023 07:46:00 PM	FOLLOWING TOO CLOSELY	FOLLOWING TOO CLOSELY	7500	S	STATE ST	623.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	2.0	18	7	9	41.758092	-87.624902	POINT (-87.624902228247 41.758092176383)
817719	61c8dcd63fae60613bc9ec526fa901420cbe99a6d35840052c27bbd0cf1f8d6af74ff575276d3795f26878601232f6b9297b250a3499b62a96373e068134d21a	NaN	07/10/2023 12:29:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	TURNING	FOUR WAY	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	NO INJURY / DRIVE AWAY	NaN	NaN	NaN	OVER $1,500	07/10/2023 01:05:00 PM	IMPROPER TURNING/NO SIGNAL	IMPROPER LANE USAGE	1800	S	UNION AVE	1235.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	2.0	12	2	7	41.857531	-87.644929	POINT (-87.644928607359 41.857530859236)
817720	54d55bfcc6627f587abbe0d14c42e51b812f930566fb06773f93b4402cb25e01bdba2a8e977644f53be3b63f9abca96a80ff6b36f6e0c0c4e3d6f3efaed136a0	NaN	12/28/2019 01:16:00 AM	35	UNKNOWN	UNKNOWN	CLEAR	DARKNESS, LIGHTED ROAD	PARKED MOTOR VEHICLE	ONE-WAY	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	Y	OVER $1,500	12/28/2019 01:18:00 AM	OPERATING VEHICLE IN ERRATIC, RECKLESS, CARELESS, NEGLIGENT OR AGGRESSIVE MANNER	NOT APPLICABLE	219	W	115TH ST	522.0	NaN	NaN	NaN	NaN	NaN	NaN	5	NO INDICATION OF INJURY	0.0	0.0	1.0	1	7	12	41.685142	-87.628557	POINT (-87.628556919131 41.685141540233)
817721	6b6f5ceb4053bfbb3483fb453231caa94ff2351bde4c9d2e9398184ae92621933b7fcecb831289f93a18d8579f23ff5dbae1e25a1bad7dc5f53ee64f45492640	NaN	10/23/2019 01:32:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	PEDESTRIAN	DIVIDED - W/MEDIAN (NOT RAISED)	NaN	STRAIGHT ON GRADE	DRY	NO DEFECTS	NaN	INJURY AND / OR TOW DUE TO CRASH	N	NaN	NaN	$500 OR LESS	10/23/2019 01:36:00 PM	RELATED TO BUS STOP	NOT APPLICABLE	20	W	79TH ST	623.0	Y	Y	NaN	NaN	NaN	NaN	2	INCAPACITATING INJURY	2.0	2.0	0.0	13	4	10	41.751046	-87.625378	POINT (-87.625377942917 41.751045778094)
817722	2ee6209bde600a6ae2f12fb385b1e5749803cc01d0e954d5016091ecb13f424d48e097f71fa5d95741f5870f7d3a76d9189293c77411b3b92c925d26239872b3	NaN	05/29/2023 09:40:00 PM	30	UNKNOWN	UNKNOWN	CLEAR	DARKNESS	TURNING	OTHER	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NaN	NO INJURY / DRIVE AWAY	NaN	NaN	Y	OVER $1,500	05/29/2023 09:59:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	3500	S	WENTWORTH AVE	915.0	NaN	NaN	NaN	NaN	NaN	NaN	2	NO INDICATION OF INJURY	0.0	0.0	2.0	21	2	5	41.830922	-87.631651	POINT (-87.631650518377 41.830922441769)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category